Skip to Content
author's profile photo Former Member
Former Member

This Year VS Last Year Comparison in Webi 3.1

Hello,

I'm struggling with a Webi report that I have built on top of a few Universes which are built from BEx queries. The Webi report has 9 reports and 7 queries all together. The Bex queries all have a customer exit built for the filter Calday and I use this customer exit in all the bex queries being used for this report to allow the user to put only 1 set of dates and that feeds all the reports within the webi report. The issue I am having is.. One of the Webi reports is suppose to do a Year over Year comparison. For example the user would put "From date" of 6/1/2013 and "To Date" 08/31/2013 and what this report does is provides a crosstab with Month Number/s(down) and Year(across) showing the key figure Sales and it works great BUT I need to in the next column provide the exact dates for the year before. See my example below (envision this being a crosstab)

What is the best way to get the 2012 data???

MONTH
2013
2012
6 $1,000 ?? 7 $1,500 ?? 8 $1,250 ??

Using Bobj 3.1 and BW 7.0

Thank you,

Jennifer

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Sep 23, 2013 at 11:58 AM

    Hi Jennifer,

    The offsets are the way to go and you are close!

    Remove the variable on Cal Day from the Filter section of the query, this is limiting you to only seeing either the current year or the previous year. But you want both!

    In your 1st selection of Key Figure add the Cal Day variable selection there.

    Copy and paste this selection to make a 2nd Key Figure and change the offsets in your second selection to -365.

    With regards

    Gill

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2013 at 05:40 PM

    Hi,

    you can easily achieve that in the BEx query by using an offset.

    ingo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jennifer,

      Could you please check the logic implemented on the exit. Based on the above screen shot, you are passing only a single value and the exit builds the range of selection. if you input from date as

      6/1/2013 and "To Date" 08/31/2013. the above restriction calculate only 06/1/2013-365

      Thanks,

      Jino.

  • Posted on Sep 20, 2013 at 05:11 AM

    Hi Jennifer,

    If you are getting the data for two years into report you can calculate in report it self,

    Please use this logics:

    i) If you use prompt date as in put for the year:

    =FormatNumber(Year(UserResponse(""To Date" "))-1;"#")

    ii) Based on current date:

    =FormatNumber(Year(CuurentDate())-1;"#")

    It works only with summarized key figures not with database delegated key figures.

    To change the aggregation of measure go to universe and objects properties change the aggregation to Sum.

    Thanks,

    G Sampath Kumar


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 22, 2013 at 07:05 PM

    Hi,

    Don't you have relative value function in Bobj 3.1?

    If yes, then you can try that option to meet the requirement, I believe!

    Br

    Prabhith

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2013 at 12:20 PM
    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.