This content has been marked as final. Show 6 replies
887111 wrote:Try this:
The pivot table ignores the sort on the measrure in the criteria section, so how can we enable sort on the measure columns in pivot in OBIEE 11g ?
1) Make a duplicate layer of the measure column.
2) Move the duplicate layer to the far left in the Rows section.
3) Apply the desired sort order.
4) Hide the duplicate layer column.
We have upgraded to 22.214.171.124.6 but stilll it shows the same.
Not sure if the patch application was not right ? We dint apply patch for EPM (patch 2). Will it affect the BUGS not getting refreshed ?
I tried the option you have given, but that sorting is not applying on the data even that option is available there.
FYI, we are using Oracle Business Intelligence 126.96.36.199.2. Is it due to different version??
Check with this once....
Please mark if its help you...
Thanks for the info.
I tried this option as well earlier, but no luck. Even I tried by Level based measure approach which was given here
Let me know if any other options available.