CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension.
Rules and TurboIntegrator
CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension.
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.
Use ConsolidatedCountUnique function to count the unique elements in the consolidation and apply it in the rule to populate in the Product Scorecard cube.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book
