Bex query calander year/month with calculated keyfigures.

[Former Member]

Hi Bw gurus,

i created a query which takes only one calendar month to display Items and sales and average on hand values.

(Average on hand is a calculated key figure which is an average of past 12 months on hand value (on hand in month+ on hand in month-1+.........on hand in month-12)/12).

Now i created same query based on above query but I used calendar year/month interval variable instead of single variable entry. i am getting all the fields with exact values but average on hand (calculated key figure value) is showing wrong data.

Your valid solution deserves the points.

Thank you.

[Former Member]

Thanks for your response gaurav, here is a brief description about the problem.

Calendar month is variable entry with interval and user exit processing type.

example- the query designer looks like this

rows contain:Item,plant,days onhand, calendar year/month (characteristics)

columns contain :sales,turnover,average on hand value, on hand value current month,on hand value at 1month before, on hand value at 2 months before……..on hand value at 11months before to the current month(structure with keyfigures)

Where sales and turnover are key figures,

But the rest are calculated keyfigures. Where the formula for Average on hand value =

((on hand value in the current month + on hand value at 1month before + on hand value at 2months before+.......on hand value at11months before to the current month)/12).

i am getting all the values exactly if i enter calendar year/month as one month only(example-06.2007).

But if i enter the interval months like 04.2007 to 10.2007 then i am getting wrong values at average on hand key figures. Rests of the key figure values are correct.

I hope this message is delivering exactly what i wish to say.

[Former Member]

Can you give example wht you want and what is going wrong>?

This will help to visualize wht you are saying..

--SA

[Former Member]

Thanks for your response gaurav, here is a brief description about the problem.

Calendar month is variable entry with interval and user exit processing type.

example- the query designer looks like this

rows contain:Item,plant,days onhand, calendar year/month (characteristics)

columns contain :sales,turnover,average on hand value, on hand value current month,on hand value at 1month before, on hand value at 2 months before……..on hand value at 11months before to the current month(structure with keyfigures)

Where sales and turnover are key figures,

But the rest are calculated keyfigures. Where the formula for Average on hand value =

((on hand value in the current month + on hand value at 1month before + on hand value at 2months before+.......on hand value at11months before to the current month)/12).

i am getting all the values exactly if i enter calendar year/month as one month only(example-06.2007).

But if i enter the interval months like 04.2007 to 10.2007 then i am getting wrong values at average on hand key figures. Rests of the key figure values are correct.

I hope this message is delivering exactly what i wish to say.

[Former Member]

Hi

It seems to me that on hand value is some particualr value at specific month .likewise on hand before month is value one month ebfore....but now if you give range : what does your onhand value previous month is suppossed to contain?

I mean to say tht onhand value previous month does NOt make sense to me..

It has to be single value not range...

Confirm with business and get some examples what they need when they say range...

--SA