Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 19, 2016 at 09:00 PM

    Found the Solution, Issue is that any filters added in Default Values are ignored by Webi not sure why.

    Added the Cal month/Year Varible in Characteristics restriction with offset value on Current Calmonth and issue was resolved!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 08:20 PM

    Ideal way to handle by customer exit in the Bex.

    otherwise you will end up to get more data in webi and then limit in webi display with variable & filter.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.