Forum Discussion
What is the percent consolidation on the Entity within the Stat hierarchy? You could use the Org-By-Period Elimination if you are utilizing Percent Consolidation between the hierarchies. Here is an explanation from the Foundation Handbook:
Org-By-Period Elimination
The Org-By-Period Elimination Consolidation Algorithm Type uses the calc-on-the-fly Share – as in Standard – but has unique elimination considerations. When determining if the data cell’s IC Member is a descendant of the Entity being consolidated, this Consolidation Algorithm Type considers the position of the Entity in the hierarchy and also checks the Percent Consolidation for every relationship down the hierarchy. If Percent Consolidation is zero for the particular relationship, the IC Member is determined not to be a descendant 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.
Currently 0. Because that entity is not getting consolidated at the moment.
Do you think if it's possible to create some kind of custom script to delete O#Elimination if the IC# an entity with an ownership type Equity for example?
- EricOsmanski2 years agoValued Contributor
Ok, in that case then the Org by Period Elimination Consolidation Algorithm Type would fit your requirements. However, this would need to be tested against any historical data without knowing more about the full Design of the application.
You could definitely write a custom script, but in this case it may not be needed.
Related Content
- 3 years ago
- 11 months ago
- 6 months ago