ConsolidatedCountUnique function for IBM Planning Analytics (TM1)

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

In this video, ConsolidatedCountUnique is used to count the unique elements in the consolidation and apply it in the rule to populate in the Product Scorecard cube.

Where can the ConsolidatedCountUnique function be used?

Rules and TurboIntegrator

Which TM1 Server version is the ConsolidatedCountUnique function available for?

Version 11 and 12

What is the syntax for ConsolidatedCountUnique?

ConsolidatedCountUnique( flag-value, unique-along-dimension-name, cube-name,element_1, element_2, … )

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