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
ConsolidatedCountUnique Rule and Suppress Zero
- 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
You need to "feed" this consolidated element by feeding one of it's children
-
- 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
Thanks for answer.
Is it means that I have to turn this measure into consolidation element and put under some element which is fed ?
Is it means that I have to turn this measure into consolidation element and put under some element which is fed ?
-
- 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
yes, it means 
I've tested above and it works

I've tested above and it works