Hello gurus,
I need to build a financial report with last 12 months, I don't have a 0CALMONTH object in my cube/multicube but atleast want to show the last 12 periods. We have Fiscal year variant, Fiscal year, Fiscal year/Period, Posting period but no variable which can bring last 12 months. Example I select Posting period as 6 for fiscal year 2005. I need a report which shows all the periods from 6 of 2004 to 6 of 2005. Is there an SAP exit already built for this requirement or how do I build one or will it help with a variable offset. I am not getting proper values with offsets.
Please help and you will be well rewarded.
Thanks,
Nikki