ConsolidatedCount function for IBM Planning Analytics (TM1)
ConsolidatedCount returns the number of values in a consolidation.
In this video, ConsolidatedCount is used 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.
Where can the ConsolidatedCount function be used?
Rules and TurboIntegrator
Which TM1 Server version is the ConsolidatedCount function available for?
Version 11 and 12
What is the syntax for ConsolidatedCount?
ConsolidatedCount(flag-value, cube-name, element_1, element_2,… )
- Flag-value
- 1 – Use consolidation weighting.
- 2 – Ignore zero values when computing the minimum value.
- 3 – Use consolidation weighting and ignore zero values.
- cube-name = Cube name.
- element_1, element_2 = Dimension element name
Relevant Functions
- ConsolidateChildren = Forces consolidate value to be calculated by summing immediate children
- ConsolidatedAvg = Returns the average value in a consolidation
- ConsolidatedCount = Returns the number of values in a consolidation
- ConsolidatedCountUnique = Counts the unique elements of the consolidated cell in one dimension
- ConsolidatedMax = Returns the maximum value in a consolidation
- ConsolidatedMin = Returns the minimum value in a consolidation