Print Page - Can i do this in transformer?

Title: Can i do this in transformer?
Post by: techieaman on 12 Jan 2009 08:40:41 AM

Hi All,

I have two dimensions - Product Dimension & Date Dimension (Granularity is at Month Level) and one fact - Revenue Fact . I need to build a KPI - % Growth Revenue whose calculation is % Growth Revenue = ((YTD Revenue - YTD Revenue for the same period last year)/(YTD Revenue for the same period last year) *100.

Can anyone tell me how to go about doing this? I believe Relative time categories have to be built here?

Please reply asap.

Thanks in advance

Aman

Title: Re: Can i do this in transformer?
Post by: dlafrance on 05 Mar 2009 01:13:56 PM

Try doing a 'YTD Grouped' as a relative time inside the time dimension

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: techieaman on 12 Jan 2009 08:40:41 AM