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
ConsolidatedCountUnique
-
- Posts: 36
- Joined: Tue Sep 07, 2010 11:34 am
- OLAP Product: Cognos TM1
- Version: 10-2-2
- Excel Version: 2014
-
- Posts: 42
- Joined: Fri Apr 19, 2013 7:07 pm
- OLAP Product: TM1
- Version: 10.1 RP1 FP1
- Excel Version: 2003 SP3
Re: ConsolidatedCountUnique
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.
-
- Posts: 36
- Joined: Tue Sep 07, 2010 11:34 am
- OLAP Product: Cognos TM1
- Version: 10-2-2
- Excel Version: 2014
Re: ConsolidatedCountUnique
Thanks alot....I was hoping that it could...i have to find another way of doing what i need to do...