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
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
Hi Stuart,
Thanks a lot for sharing the helpful information.
Regards,
Amritha