OBIEE 12c data is showing null values if we arrange the columns in report. Source is essbase

A Ali

OBIEE 12c

Essbase 11.1.2.4.500

We have bi reports which has Essbase as data source. We are seeing issue when we bring the columns in a certain order it work fine. But if we change the columns then the report return null values. It was working fine in 11.1.1.7. Recently we upgrade to BI 12c

We also notice if we don't have parameters then the reports work fine

This is the error we are seeing. Any help is really appreciated

Saresh-Oracle

Hi,

Please try this:

1. Log into Answers.
2. Open the problematic analysis in edit mode.
3. Click on the Advanced tab.
4. In Prefix section set the following:
   

   set variable PERF_ENABLE_ASYMMETRIC_COND_OPTIMIZATION = 1;

5. Apply and retest the issue

Thanks,

Sareesh