Consolidation in a Dynamic Cube

Question

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?

JackLacava · Answer

Look at the solution for this post: Dynamic Cube Data Load from BiBlend Table | OneStream Community

The main point is: you are in charge of returning the right records for each dataunit. If you don't check the dataunit level correctly (in the same way as you would in consolidation rules, in practice) and return the same values everywhere, things won't look right.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded