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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book