Time Dimension Issue in Calculation...

[Amritha]

Hi All,

I have made a cube shown below. I want to compute "Revenue Growth %" in Q2-2010 by taking (Revenue of Q2-10 minus Revenue of Q1-10) / (Revenue of Q1-10).
However, I am not sure how to do this, since the computation is spanning across a different "timeline" d-list as well.


Rows i have 'Revenue calculation' and columns as 'Time Dimension as Quarters' and in Pages ' Cost centres'


                           Q12010   Q22010   Q32010    Q42010  Total -2010  Q12011.......Q42011 Total-2011
Revenue                  0              0          0            0            0              0               0            0
Revenue Growth        0             0           0            0            0              0               0            0


Any hint/help in terms of how to achieve this? Also hw can we prevent the cross reference issue while creating dimensions, any best practices.

Thanks in Advance...

Regards,
Amritha

[StuartS]

You will need to use an additional row and use the @Lag Bif function.  This can be used to bring the revenue for the previous period forward and then be used in your calculation,  e.g.

	Q1-2010	Q2-2010	Q3-2010
Revenue	10	12	15
Revenue Lag		10	12
Revenue Growth		20%	25%

The Bif is @Lag(1;0;{Revenue})

regards

Stuart

[Amritha]

Hi Stuart,


Thanks a lot for sharing the helpful information.


Regards,
Amritha