New to OneStream - Account Dimension build
Hi,
I'm new to OneStream and wondering if this Account rollup is possible using inherited Account dimensions?
Cube 1 is the Main cube and needs to show all Accounts, but the Cube2&3 should only s...
Forum Discussion
This seems the most direct way of doing it:
Cube1:
Cube 2:
Cube 3:
Anything that is common aross all 3 cubes, I put on the parent Cube1 Hierarchy... but my question is really does Cube 1 allow inputs on the lower levels?
Does Cube 1 even see the detailed accounts? and/or does Cube 2 and Cube 3 see the parent accounts defined in Cube 1?
Cube 2 and 3 will see parent Accounts, they are automatically aggregated.
Cube 1 will only see data for DT_REVENUE and DT_COST, it will not know anything about lower levels.