If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Hide a Category for a Dimension

Started by Kiran Kandavalli, 15 Jan 2021 03:37:21 PM

Previous topic - Next topic

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