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

Setting consolidation operator to ignore in ASO

in Planning 4 comments

Hi All

My entity dimension structure has a parent with 3 children. Data storage for all is set to Dynamic Calc.

One child must to not roll up to the parent so I need to set the consolidation operator to ignore. But documentation indicates that you have to set the parent to 'Label Only' to have a consol operator set to ignore, but that is not possible. Another way we tried was to set the member formula of the child in question to 0.

When we tried to refresh the db , it errored with hierarchy type of the parent cannot be 'stored' so we changed that to dynamic which allowed the db refresh , but then caused bizarre errors with our YTD (View) PCP (Scenario) calcs and dramatically slowed down our queries.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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