ConsolidatedCountUnique Rule and Suppress Zero

Post Reply
czareba
Posts: 3
Joined: Thu Dec 22, 2016 11:16 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2013

ConsolidatedCountUnique Rule and Suppress Zero

Post by czareba »

Hi,
In my cube I've got rule like this:

['uniq_cnt'] = C: ConsolidatedCountUnique(2, 'DIM_UQ','', !DIM1, !DIM2...., 'measure_for_uq' ) ;

It calculates properly, but when I enable "suppress 0" option, this element disappears from view.

How can I display this measure with "suppress 0" enabled ?

And I have another related question.
I'm trying to build a report in Cognos Report Studio and I'm getting only data which I see in Cube Viewer with "suppress 0" enabled.
Is there possibility to force Report Studio to get data like displayed in view with "suppress 0" disabled?

Thanks in advance for any help with these issues

Czarek
User avatar
Elessar
Community Contributor
Posts: 413
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: ConsolidatedCountUnique Rule and Suppress Zero

Post by Elessar »

You need to "feed" this consolidated element by feeding one of it's children
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
czareba
Posts: 3
Joined: Thu Dec 22, 2016 11:16 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2013

Re: ConsolidatedCountUnique Rule and Suppress Zero

Post by czareba »

Thanks for answer.

Is it means that I have to turn this measure into consolidation element and put under some element which is fed ?
czareba
Posts: 3
Joined: Thu Dec 22, 2016 11:16 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2013

Re: ConsolidatedCountUnique Rule and Suppress Zero

Post by czareba »

yes, it means :)
I've tested above and it works
Post Reply