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

Calculate member in a Dimension (Transformer)

Started by mycognos, 27 Mar 2009 01:13:49 AM

Previous topic - Next topic

mycognos

Hi,

Can anyone tell me what are calculated members in a dimension and how to create those? I have a 'Current Year' column and 'Prior Year' column and I have to create a calculated members called :

'Current Year' minus 'Prior Year' and
'Current Year' minus 'Prior Year' devided by 'Current Year'

Thanks in advance...

norah

you can drag a new category from the parent dimension,and change it to calculated category,then you can define the expressions which you want in the Expression Editor