We have got a local process chain with many packages to import data from other cubes.(BW 3.5) The main Idea is that we do not need all data from the source cubes in our destination cubes. We need to limit data transfer by 0CALLDAY.
The useal method is to enter period in the packageparameters.
But this procedure is regular with changing range of 0CALL day.We do not want to set up variables in every package each time we need to transfer data.
Can we use some kind of CHANGING VARIABLE in 'DATA SELECTION' part of the package?
A lot of thanks in advance!
Ashish Tewari replied
You don't have to put period every time before running your IP. You can use either a OLAP variable or ABAP routine according to your requirement.
On Data Selection screen of IP, you can use type 6 for routine and type 7 for OLAP variable.
Sample code for routine
data: w_month(6) type n, from_date type sy-datum, to_date type sy-datum. w_month = sy-datum(6). concatenate w_month '01' into from_date. concatenate w_month '01' into to_date. l_t_range-low = from_date. l_t_range-high = to_date. l_t_range-sign = 'I'. l_t_range-option = 'BT'. modify l_t_range index l_idx.
Just find out whether any OLAP Varibale fulfills your requirement or not. Otherwise Routine can be used.
Hope it helps...