TM1 Function for Rules, CONSOLIDATECHILDREN

CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children.

**Where can the CONSOLIDATECHILDREN****function be used?**Rules

**Which TM1 Server version is this function available for?**

Version 11 and 12

**What is the CONSOLIDATECHILDREN****function?**CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children.

**What is the syntax for CONSOLIDATECHILDREN?**ConsolidateChildren(DimName1, DimName2, …)

DimName1 = Dimension name.

DimName2 = Dimension name.

**CONSOLIDATECHILDREN****A demonstration on how to use**Use ConsolidateChildren function to calculate consolidate values by summing immediate children values and apply it in the rule to populate in the Product Scorecard cube.