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