Legacy Business Intelligence > COGNOS Transformer

How to Hide a Category for a Dimension

(1/1)

Kiran Kandavalli:
Team,

In the Source Report I created a Category Column and in that column I have expression as below

Case
Condition 1 then ('Primary')
Condition 2 then ('Secondary')
else ('N/A')
End

So when I publish the Cube this Dimension shows all these 3 values

Primary
Secondary
N/A

Is there a way that we can hide the N/A category and the Total should be based on Primary & Secondary.

Please suggest on this!

Thank you!
Kiran

Navigation

[0] Message Index