Calculate Moving Average

[Former Member]

How to Calculate 3 months moving average/Rolling average

[glenleslie]

You've got a few options...

1. create a KF Infoobject which uses exception aggregation by a time characteristic

2. create a Calculated KF with average as the aggregation in the properties. In the report, use offset restriction of -3 off of the SAP delivered current month variable or month to date.

Glen

[Former Member]

Hi, Glen.

May I ask for some clarification, please? My application is actually for rolling 12-month totals (very similar to moving averages), calculated for each month for a selected range of years which can (and does) go back to 1983.

I don't believe it is possible to do this within BEx - do you agree?

I believe it IS possible to do it by enhancing an extract structure, BUT I am loading data from a flat file so this is not possible in my situation.

I would like to do it within the Transfer rules, but the calculation inherently requires multiple records to be read at the same time in order to calculate the result, and I don't think it is possible to read multiple records at the same time with transfer rules. Is that right?

What would you recommend? Is it possible to populate a new key figure for an ODS based on the existing contents of the ODS?

Or maybe I have to create a new ODS and populate it with data from the first ODS plus the new key figures?

I would prefer to avoid the latter due to data redundancy and added complexity.

It seems to me like it should be a frequently-encountered situation that many have previously resolved - I would very much appreciate any advice that you - or others - can offer.

Best regards,

Patrick Byrd

[Former Member]

Hi, Glen (or anyone else!).

This is still an issue I am attempting to resolve... any thoughts please?

Patrick