Setting consolidation operator to ignore in ASO
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.