Skip to Content
0
Jul 19, 2016 at 07:56 PM

Display previous 3 and future 9 months using 0CALMONTH in Webi

169 Views

Hello Gurus,

On one of my requirement I need to display chart having Current month -3 and Current month +8 dynamically rolling for 12 months. So if report is run in July it should pick last three months and future 8 months and current month on the report, This is monthly report and everymonth they will run without user input. Back end of this data is Bex, I used offset variable which shows correct results in Analyzer However when the report is developed in Webi it simply ignores those offset variables. User Exits are not supposed to use for this one at client.

Due to this reason I am planning to acheive this logic at Webi level. Any inputs appreciated!

Consider below output as Jul-16 Current Month!

Cal Year/month Values Apr-16 4 May-16 8 Jun-16 114 Jul-16 71 Aug-16 96 Sep-16 17 Oct-16 24 Nov-16 3 Dec-16 5 Jan-17 1 Feb-17 2 Mar-17 15 Apr-17 7




Thanks,

Sam