TM1 Function for Rules, CONSOLIDATECHILDREN
CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children.
Where can the CONSOLIDATECHILDREN function be used?
Rules
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.
A demonstration on how to use CONSOLIDATECHILDREN
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.