Rule Functions

TM1 Function for Rules – CONSOLIDATEDCOUNT 

Available In

Rules and TurboIntegrator

Definition

​CONSOLIDATEDCOUNT returns the number of values in a consolidation. 

Syntax

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.

Video Demo

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.