Obiee 11g Pivot View: Cannot Group Records Based On An Aggregation Column (Doc ID 2026589.1)

Last updated on AUGUST 18, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.7.140225 [Release 11g]
Information in this document applies to any platform.

Symptoms

You are trying to create an analysis with a calculated column like this:
CASE WHEN RANK("Calculated Facts"."All Products Revenue" ) <=5 THEN "Offices"."Office"  ELSE 'Others' END

You want to show the first 5 values and then cluster all the others in one single group called "Others".


So you created a pivot that contains the calculated column in row and the measure. What you get is just 1 row with the total sum for the measure and only the first value of the calculated column. it is expected to have 6 rows: the first top 5 and then the "Others" row.


In order to get the desired results, you checked the calculated column with "Treat as an attribute column" flag, but we get the following error:

 

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