TM1 Function for Rules – CONSOLIDATEDCOUNTUNIQUE

Knowledge Hub

TM1 Function for Rules, CONSOLIDATEDCOUNTUNIQUE

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

Where can the CONSOLIDATEDCOUNTUNIQUE function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the CONSOLIDATEDCOUNTUNIQUE function?

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

What is the syntax for CONSOLIDATEDCOUNTUNIQUE?

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.

A demonstration on how to use CONSOLIDATEDCOUNTUNIQUE

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