Skip to Main Content

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!

Cube not aggregating correctly

2889517May 6 2016 — edited May 13 2016

Folks -

I'm having an issue where my cube is not aggregating correctly.

It's showing a total as "Total Department" thats higher than actually what exists, based on manual math.

I've done the following:

  1. Re-aggregated the code
  2. Validated aggregation operators
    1. All members set to +
  3. SET AGG Missing ON in calc script
  4. Agg missing on is NOT checked off on data base

Does anyone have any ide or quick things to check?

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2016
Added on May 6 2016
5 comments
1,186 views