Skip to Content
0
Former Member
Feb 24, 2009 at 12:20 PM

Query Variables

34 Views

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