TM1 Function for Rules, CONSOLIDATEDAVG
CONSOLIDATEDAVG returns the average value in a consolidation.
Where can the CONSOLIDATEDAVG function be used?
Rules and TurboIntegrator
What is the CONSOLIDATEDAVG function?
CONSOLIDATEDAVG returns the average value in a consolidation.
What is the syntax for CONSOLIDATEDAVG?
ConsolidatedAvg(flag-value, cube-name, element_1, element_2,… );
Flag-value 1 – Use consolidation weighting.
Flag-value 2 – Ignore zero values when computing the minimum value. Flag-value 3 – Use consolidation weighting and ignore zero values.
cube-name = Cube name.
element_1 = Dimension element name.
element_2 = Dimension element name.
A demonstration on how to use CONSOLIDATEDAVG
Use ConsolidatedAvg function to calculate average value in a consolidation and apply it in the rule to populate the Avg_Value measure in the Product Scorecard cube.