Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE calculates Grant Total in a Pivot Table wrong when using selection steps and groups?

Received Response
23
Views
2
Comments
maltedietsch
maltedietsch Rank 2 - Community Beginner
edited Aug 13, 2024 5:13PM in Oracle Analytics Forum

Hi,

I have a Pivot Table in Answers that looks like this:

Diesel and Gas are Members of a dimension.

D+G is just a group containing Diesel and Gas.

Now OBIEE does not calculate the sum on the right in some cases and in other cases, the sum is wrong.

I have tried already all aggregation functions on the Measure, to no avail.

Anybody know how this can be corrected? Is this a bug?

Thanks

Tagged:

Answers