Page 1 of 1

ConsolidatedCountUnique Rule and Suppress Zero

Posted: Fri Dec 23, 2016 1:05 am
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

Re: ConsolidatedCountUnique Rule and Suppress Zero

Posted: Fri Dec 23, 2016 8:04 am
by Elessar
You need to "feed" this consolidated element by feeding one of it's children

Re: ConsolidatedCountUnique Rule and Suppress Zero

Posted: Fri Dec 23, 2016 12:00 pm
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 ?

Re: ConsolidatedCountUnique Rule and Suppress Zero

Posted: Fri Dec 23, 2016 3:06 pm
by czareba
yes, it means :)
I've tested above and it works