OBIEE 11g Column Formula With Total Sum Incorrectly Showing Multiple Rows When Using A Hierarchy (Doc ID 2054540.1)

Last updated on SEPTEMBER 25, 2015

Applies to:

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

Symptoms

The column formula with SUM is incorrect if dimension column is excluded.

Using a hierarchy for the column & formula for the Grand Total and expecting one rows per Product number, but we are seeing multiple rows displayed.




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