Forum Discussion
SaraB
3 years agoNew Contributor III
Consolidation with cascade entity structure
Hi,
We have a cascade entity structure, where one of the sub-elements consolidates up to a certain period, and after that period the other begins to consolidate.
Entity A1 has an investmen...
- 3 years ago
The problem was in the section "Second Pass Elimination", all the other sections were OK.
Thank you!
EricOsmanski
OneStream Employee
3 years agoThere are other implementation specific considerations, but for this particular question you will need to use the Cube Consolidation Algorithm Type of "Org-By-Period Elimination". You can read about this more in the Design and Reference guide but here is the additional information:
"When determining if the data cell's IC member is a descendant of the Entity being consolidated, this option considers the position in the Entity hierarchy and also checks the percent consolidation for every relationship down the hierarchy. If a percent consolidation is zero, the IC member is determined to not be a descendent of the entity."
In comparison, the standard elimination (hierarchy elimination) only considers the position of the Member in the Entity Dimension hierarchy. Standard elimination is the default approach and does not consider Percent Consolidation.
Related Content
- 3 years ago
- 3 years ago
- 3 months ago
- 1 year ago