cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

yasemin_kilinc
Active Contributor
0 Kudos

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
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

former_member182470
Active Contributor
0 Kudos

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.