OBIEE 11g. Pivot Table Columns are Grouped and cannot be Removed after Upgrading from OBIEE 10g (Doc ID 1610491.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading from OBIEE 10g, to 11g, in your pivot views, you see a Column Group column in the Criteria tab. For example:

Column Group (Default: Quarter Name)
Column Group (Default: Sales VP)

Because of this new column, the results are displayed in a different way. When you come return to the criteria tab and try to remove the new column, there are no delete/column properties options available.

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