ConsolidatedCountUnique

Post Reply
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

ConsolidatedCountUnique

Post by mukeshrajdass »

ConsolidatedCountUnique( 0, unique-along-dimension-name, cube-name,elem_1, elem_2, . . . );

Arguments element_1 through element_n are sequence-sensitive. element_1 must be an element from the first dimension of the cube, element_2 must be an element from the second dimension, and so on.
These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.

Will it work for Non-Alias Text attributes instead of Dimensions or Alias attributes ?? Has anyone tried it ??


Thx
TableManagerOne
Posts: 42
Joined: Fri Apr 19, 2013 7:07 pm
OLAP Product: TM1
Version: 10.1 RP1 FP1
Excel Version: 2003 SP3

Re: ConsolidatedCountUnique

Post by TableManagerOne »

I'd expect it would not work because text attribute values do not need to be mutually unique among elements of a dimension. If you used a non unique attribute, TM1 wouldn't know which element you were referring to.
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

Re: ConsolidatedCountUnique

Post by mukeshrajdass »

Thanks alot....I was hoping that it could...i have to find another way of doing what i need to do...
Post Reply