ConsolidatedCountUnique function for IBM Planning Analytics (TM1)

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