Rows with NA Values Are Getting Suppressed in 11.2.0.4 and 12.1.0.x (Doc ID 2020751.1)

Last updated on NOVEMBER 09, 2015

Applies to:

Oracle OLAP - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------
When looping over "Cube Stored Variables", NA values are being suppressed. Output contains rows only for non-NA values. This is working fine in 11g(11.20.3).

For ex: We have created a simple test case between 11g and 12c.

TEST_CUBE has two dimensions PRODUCT and CUSTOMER.

allstat
limit product to '1' '2' '3'
limit customer to 'a' 'b'
rpr down product test_cube_price
show joinlines(charlist(joinchars(product joinchars(',"',customer,'"' , ',' ,'"',convert(test_cube_price text 0 no),'"'))))

11g Output: (Loops over all combinations of Dimensions PRODUCT and CUSTOMER)

1,"a",""
1,"b","100"
2,"a",""
2,"b",""
3,"a",""
3,"b",""


12c Output: (See only non-NA rows)
1,"b","100"

Changes

 Upgraded to 11.2.0.4 or 12c.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms