on 01-21-2015 11:25 AM
Hi Expets,
I have one requirement splitting two year YTD data into Month wise value in 24 columns after calculation in Bex Query Designer.
Here infoprovider as a Infocube YTD starting month is April.
Data In Cube | |
April | 40 |
May | 60 |
June | 100 |
In Bex Query After Calculation
April | May | June |
40 | 20 (40-20) | 40 (100-60) |
For this I have applied that did 3 selections in and then after each value maintained in separate key figure but performance is very less.
Any possible solution how to make this dynamic in optimized way for 2 years.
Regards,
Somesh.
Hi Somesh,
If your issue resolved, please close this thread by selecting "Correct Answer"
Thank you,
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Somesh,
You can keep 0CALMONTH in columns under that add key figure.
Create variable for 0CALMONTH and update FROM & TO values in customer exit.
No need to create multiple selections.
Thank you,
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Somesh,
CASE i_vnam.
WHEN 'your variable name'.
IF i_step = 1.
LOOP AT i_t_var_range INTO loc_var_range WHERE vnam = 'your variable name'
l_s_range-low = date1
l_s_range-high = date2
l_s_range-sign = 'I'.
l_s_range-opt = 'BT'.
APPEND l_s_range TO e_t_range.
CLEAR l_s_range.
endif.
OR
You can check standard variables in below link.
Thank you,
Nanda
Hi Nanda,
Thanks again, as per your suggestion i will work for single column for all month but i need to populate month wise data individually in each column before that have to do calculation MTD.
Eg:
InfoCube Data (YTD DATA)
04.2014 20
05.2014 60
06.2014 100
Query output should be.(BEX QUERY OUTPUT)
Entry Variable: 06.2014
04.2014 05.2014 06.2014
40 20 40
40 (40 - 60) (100 - 60)
Thanks,
Somesh.
Hi Somesh,
We have fill the e_t_range table with FROM & TO values like 06.2014 goes to LOW and 04.2014 goes to HIGH.
Place 0CALMONTH in COLUMN and under calmonth place key figure and select property cumulative either row or column,
l_s_range-low = date1
l_s_range-high = date2
l_s_range-sign = 'I'.
l_s_range-opt = 'BT'.
APPEND l_s_range TO e_t_range.
CLEAR l_s_range.
OR
You can check any standard variable which will give FROM and TO dates as per current date, then no need to write code also.
But you have keep calmonth and key figure in COLUMN and select cumulative row wise or column wise.
Pls check this.
Thank you,
Nanda
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.