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

BEx report with CalMonth in column and qty in row for prior months

Hello,

I have a requirement to create a BEx query where i need to achieve below results

Columns = Months, rows = Qty

Desired layout

(columns) July'13 Aug'13 Sep'13

(rows)

Qty(on 1st business day of month) July'13 data Aug'13 data Sep'13 data

Qty(on 1st business day of month for 3 mnths prior) May'13 data Jun'13 data Jul'13 data

Any suggestions would be highly appreciated.

Thanks,

MNK

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2013 at 07:28 AM

    Hi Mnar,

    I think you can do it with a modification in modeling side of infoprovider to show -3 months data for a month. Add a new key figure to your infoprovider, in end routine you can write a small abap code that will append the same data to your infoprovider with a difference that this time the key figure you fill in will be empty and the new key figure will be filled, and calmonth will be set to calmonth - 3. In query designer you will use these two key figures one for this months data one for -3 months data. I am not sure if I could make it clear, please let me know if there is any incomprehens...

    Hope it gives an idea

    Yasemin...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks all for your quick replies.

      Qty is not the only key figure in the report, there are other bunch of kf's. But I am having difficulty with Qty(3 months prior). I cannot swap axis since there other kf's involved in rows and user is specific about the format. KF's are not used directly there will be restrictions on kf's.

      Column will only have 0CALMONTH which is determined by input (range for calmonth).

      eg: 07/2013 - 08/2013

      (columns) July'13 Aug'13

      (rows)

      Qty1(on 1st business day of month) July'13 data Aug'13 data

      Qty2(on 1st bus. day of month for 3 mnths prior) May'13 data Jun'13 data

      ------

      -----other rows

      Qty1 I have no problem, but Qty2 how can I show May'13 qty at intersection of July'13 & Qty2 even though I offset calmonth by '-3'.

      @Yasemin,

      Doing in the backend might be a possibility, I will explore more on that.

      Any other suggestions on how to do it in the query directly.

      Thanks,

      MNK

  • Posted on Sep 05, 2013 at 06:33 AM

    This can be simply achieved by swapping axes in the report. You cannot create BEx Query with KFs in rows pane. So you have to use SWAP AXES.

    Keep Calmonth in rows and Qty in KFs pane. You can keep Qty under Calmonth as umbrella also in KF.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2013 at 07:37 AM

    Hi,

    I see that you don't have any chars in rows except the logic. In the columns you can display the qty for the months based the logic you have given. If you prefer no chars in rows, you can use a structure with dummy nodes to represt the logic text.

    The qty in columns can be derived using offsets or using exit.

    Br.,

    Venkat Ambati.

    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.