You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Problem with Aggregation using the Multiplication Operator

edited Sep 24, 2024 8:37AM in Planning 4 comments

Summary:

Problem with aggregation using the multiplication operator in a hierarchy (BSO cube).

Content (please ensure you mask any confidential information):

We are having a problem when using the multiplication operator to aggregate a hierarchy. The problem started after Essbase's version was updated this month.

For example, suppose we have the following hierarchy:

Member01 should be equal to Member02 * Member03 after the aggregation.

Now, suppose we have the following values:

Member02 = #MISSING

Member03 = 0.10

After the aggregation: Member01 = #MISSING * 0.10 = #MISSING

However, we are getting this:

Member01 = #MISSING * 0.10 = 0.10

This problem is only occurring in one cube. The other cubes we have are working correctly.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!