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, …)

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