Rule Functions

TM1 Function for Rules – CONSOLIDATEDCOUNTUNIQUE 

Available In

Rules and TurboIntegrator

Definition

​CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. 

Syntax

ConsolidatedCountUnique( flag-value, unique-along-dimension-name, cube-name,elem_1, ,. . );

  • 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.

unique-along-dimension-name = Dimension name

cube-name = Cube name. 

element_1 = Dimension element name. 

element_2 = Dimension element name.

Video Demo

Use ConsolidatedCountUnique function to count the unique elements in the consolidation and apply it in the rule to populate in the Product Scorecard cube.