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

DMR Report - Cognos TM1 Cube - Calculated Dimension

Started by venu4cognos, 26 Jun 2015 05:55:25 AM

Previous topic - Next topic

venu4cognos

Hi,

I need to create a calculated dimension in the cross tab.
I have 3 dimensions in the cross tab - Product and Channel ( row vice). and Year ( Column vice).
For the Channel, Whenever the channel has data as 'Pharma' we have to display as 'Pharma' for the rest of the values which are not Pharma - should be displayed as 'Non Pharma'.

I tried using a caption and case construct, but always returns errors.

Can you please let me know how to do this.
Thanks,
Venu