NidhiMangtani
2 days agoContributor III
Consolidation in a Dynamic Cube
Hi Experts,
I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc.
I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level?
Entity structure:
I see same data at multiple levels.
Asia and AllRegions data should not be same.
Also drill down results are same at multiple levels which is weird.
So if we are setting data at base entities in a dynamic cube, how does consolidation work here?
JackLacava , would you please clarify this?