Sorting of data in BIP report using OBIEE analysis as a data source
Hi everyone
I have an OBIEE analysis running on an Essbase cube. In the analysis, the data is returned sorted exactly the way it appears in the Essbase outline. I created a BIP report using this analysis as the data set, but now the data is no longer returned in the Essbase outline sorting order. In fact, it seems to be sorted in some random fashion. It isn't ascending or descending or according to the Essbase outline.
Can someone explain what it the logic behind the BIP sorting? What do I need to do to have the BIP report return the data sorted as per the Essbase outline? I'm using the online layout editor.
I have an OBIEE analysis running on an Essbase cube. In the analysis, the data is returned sorted exactly the way it appears in the Essbase outline. I created a BIP report using this analysis as the data set, but now the data is no longer returned in the Essbase outline sorting order. In fact, it seems to be sorted in some random fashion. It isn't ascending or descending or according to the Essbase outline.
Can someone explain what it the logic behind the BIP sorting? What do I need to do to have the BIP report return the data sorted as per the Essbase outline? I'm using the online layout editor.
0