ConsolidatedCountUnique Rule and Suppress Zero
Posted: Fri Dec 23, 2016 1:05 am
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
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