Rolling Sum in OBIEE 10G
924768Sep 26 2012 — edited Oct 6 2012Hi
I have an requirement where in we need to calculate Demand of an particular item for past 2 years plus 3months forecast * 4 (i.e demand for next 1 year) in simple words:
(Past 2 year demand + (3 months forecast *4))
How can I achive this in OBIEE 10g.
I have read that there is periodrolling function in OBIEE 11g. is there any such function in OBIEE 10g
Regards
Sameer