Hi All ,
I have a scenario where i have created one variable(ZCAL) for 0CALWEEK. Its a mandatory variable and is having range means the user has to provide the input in the range format e.g. 13/2008 - 15/2008 .
Also we have another week field called planning week . i have created one variable for this planning week(ZPLNWEEK) . the "processing by" for this variable is REPLACEMENT PATH and the variable is replace by the variable ZCAL (variable for 0CALWEEK) .
Now in the query i am restricting a keyfigure with the variable ZPLNWEEK offsetting it to -2 .
Means if the user is giving the input for the CALWEEK as 13/2008 - 15/2008 then the data which i want to be displayed for that key figure , should be of the planning week 11/2008 - 13/2008 .
But when i am executing the query the keyfigure data which is getting displayed is only of planning week 11/2008.
Means
for the 0CALWEEK value of 13/2008, the keyfigure data is getting displayed for planning week11/2008.
for the 0CALWEEK value of 14/2008, the keyfigure data is getting displayed for planning week11/2008.
for the 0CALWEEK value of 15/2008, the keyfigure data is getting displayed for planning week11/2008.
But i need that
for the 0CALWEEK value of 13/2008, the keyfigure data should get displayed for planning week 11/2008.
for the 0CALWEEK value of 14/2008, the keyfigure data should get displayed for planning week 12/2008.
for the 0CALWEEK value of 15/2008, the keyfigure data should get displayed for planning week 13/2008.
Any pointers how to achieve it ??
Thanks in advance
Sam