on 09-04-2013 11:31 PM
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.