query using 0calmonth, to input the month range, data incorrect.

[Former Member]

hi, experts,

I have a query using 0CALMONTH in the filter, restricted the range value ( eg. 2009.01-2009.08 ),

but the data in Bex Analyzer only 2009.08, doest not collect the data from 2009.01 to 2009.08.

If restrict the single value (eg, 2009.02), the data is correct.

I tried to restrict the key figure by 0CALMONTH and then tried using variables with an offset but it does not work as input is a month range.

my bw support package13, basis sp12.

thanks in advance,

xwu.

[Former Member]

I have solved this issue, the key figure exception aggregat type is last value.

thanks,

xwu.