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

Is the fixing of dimension logically correct?

edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

Is the fixing of dimension logically correct?

Content

Hi All,

 

I am just wondering whether below fixing of dimension member within FIX statment is logically correct or not ? because essbase is not throwing any error for syntax.

 

FIX(("Actual") OR (Budget,"WORKING",&VOL_CY))

 

AGG( "PRODUCT");

 

ENDFIX

 

Expectation is to aggregate the product dimension both for actual scenario for all dimension member combination and for budget with for working version and current year.

 

I know we can separate box the fixes and do the aggregation and but wondering to merge it one like above..

 

Is the correct way of doing it ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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