OBIEE 11g: Multiple Column Sorting Not Working In Pivot Table
Last updated on JUNE 14, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.0  and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0  and later
Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Information in this document applies to any platform.
***Checked for relevance on 21-Nov-2013 ***
In a pivot table if you have for example 3 dimensions then the dynamic sort on the dashboard page doesn’t work for the second/third column.
For example, here there is no sort specified:
Here there is a sort on the first column:
Here there is a sort on the third column, but the results are not sorted by this column:
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