Rule Functions

TM1 Function for Rules – CONSOLIDATECHILDREN

Available In

Rules

Definition

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

Syntax

ConsolidateChildren(DimName1, DimName2, …)

DimName1 = Dimension name. 

DimName2 = Dimension name. 

Video Demo

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.