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

[Former Member]

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

[yasemin_kilinc · Accepted solution]

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...

[Former Member · Accepted solution]

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