ConsolidateChildren function for IBM Planning Analytics (TM1)
ConsolidateChildren forces consolidate value to be calculated by summing immediate children.
In this video, ConsolidateChildren is used to calculate consolidated values by summing immediate children’s values and applying them in the rule to populate the Product Scorecard cube.
Where can the ConsolidateChildren function be used?
Rules
Which TM1 Server version is the ConsolidateChildren function available for?
Version 11 and 12
What is the syntax for ConsolidateChildren?
ConsolidateChildren(DimName1, DimName2, …)
- DimName1, Dimension 2 = Dimension names used in the cube
Relevant Functions
- ConsolidateChildren = Forces consolidate value to be calculated by summing immediate children
- ConsolidatedAvg = Returns the average value in a consolidation
- ConsolidatedCount = Returns the number of values in a consolidation
- ConsolidatedCountUnique = Counts the unique elements of the consolidated cell in one dimension
- ConsolidatedMax = Returns the maximum value in a consolidation
- ConsolidatedMin = Returns the minimum value in a consolidation