Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

OBIEE Grand Total Issue with UNION Report (Combine Reports)

Posted by sranka on May 16, 2011

Hi All

In 10g we had a bug where variance Grand Total didn’t work. John Minkjan covered it in great details at his OBIEE 101 Blog .

While using 11g for the similar variance on a report, it was nice to see the results showing up correctly. But we hit a road block when we were using a variance calculation on UNION report, YES!!!!! the variance calculation, still doesnt work when you are using combine. Oracle has an existing bug, and I have created another bug#12546303 – INCORRECT GRAND TOTAL ISSUE ON UNION REPORT.

In short if your varainace column is not working, don’t split your hair, it could be possibly a bug

More Details on Metalink:

NOTE: 941888.1,540371.1

BUG:5610580 – UNION QUERY NOT CREATING GRAND TOTAL % CALCS CORRECTLY
BUG:6655852 – PIVOT TABLE GIVES INCORRECT ANSWER IN TOTAL IN UNION QUERY
BUG:8285205 – INCORRECT PERCENTAGE VALUE IN PIVOT TABLE
BUG:8580420 – DOES NOT CALCULATE THE PIVOT TABLE VALUES CORRECTLY.
Bug 8662690: SERVER COMPLEX AGGREGATE RETURNS FIRST ROW ON THE COMBINED QUERY’S GRAND

Hope This Helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Advertisements

One Response to “OBIEE Grand Total Issue with UNION Report (Combine Reports)”

  1. Saichand Varanasi said

    thank you for reminding us!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: