TM1 Function for Rules, CONSOLIDATEDCOUNT
CONSOLIDATEDCOUNT returns the number of values in a consolidation.
Where can the CONSOLIDATEDCOUNT function be used?
Rules and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the CONSOLIDATEDCOUNT function?
CONSOLIDATEDCOUNT returns the number of values in a consolidation.
What is the syntax for CONSOLIDATEDCOUNT?
ConsolidatedCount(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 CONSOLIDATEDCOUNT
Use ConsolidatedCount function to count the number of values in the consolidation and apply it in the rule to populate the Avg_Value element in the Product Scorecard cube.