My Oracle Support Banner

OBIEE 12c: Union Of Two Data Sets In Answers Does not Show Correct Totals (Doc ID 2492738.1)

Last updated on AUGUST 31, 2021

Applies to:

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


You have created an analysis based on the union of two Subject Areas which have been created from Data Sets, you have added a Table view and have enabled subtotals and grand totals for it.

When you display the results only the first row of data is taken into account.  You have edited the column in the criteria tab and set the "Aggregation Rule (Totals Row)" attribute to "Sum" but the problem persists.

If you use each data set individually, the results are displayed correctly.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.