Print Page - Calculate member in a Dimension (Transformer)

Title: Calculate member in a Dimension (Transformer)
Post by: mycognos on 27 Mar 2009 01:13:49 AM

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...

Title: Re: Calculate member in a Dimension (Transformer)
Post by: norah on 01 Jun 2009 01:04:33 AM

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

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: mycognos on 27 Mar 2009 01:13:49 AM