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

ASO-Aggregation and calculation

Received Response
19
Views
5
Comments
edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

ASO-Aggregation and calculation

Content

I am a newbie to ASO and am encountering what seems to be a simple issue/

I have a member with a calculation formula

A = B * C

The structure of Entity Dimension is

  EntityX

        X_1

           X_123

           X_234  

  EntityY

        Y_1

           Y_123

and so on...

The Dataset is

  

                     B             C                A

X_123              20              1                20

X_234              15             #Missing       #Missing

X_1                35               1               20

I want this to be

35*1 =35 as the result. Is there any way I could modify the Solve order for this behavior to occur 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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