Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot Tables

sliderrulesAug 25 2010 — edited Aug 25 2010
Hi,

I have created a pivot table using a measure based on Year, Month, Day and a category.
I am able to drill from Year -> Month->Day. The total measure does not sum up to the correct amount on the month level, but when I check the values on the day level they aggregate to the correct amount.

There is inconsistency in the aggregation when rolling up to month level, The measure has been defined in BMM by creating a logical column and the measure has been set to SUM in the pivot table.

The difference:

Apr-10
Pivot Table - 2,202,431
Database Fact Table - 2290830.95

Can anybody help with understanding why there is a discrepancy in the measure between month and day?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2010
Added on Aug 25 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
624 views