OBIEE 11g: Multiple Column Sorting Not Working In Pivot Table

(Doc ID 1466731.1)

Last updated on JUNE 14, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.
***Checked for relevance on 21-Nov-2013 ***

Symptoms

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:


 

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