Calculation of accumulated values

[Former Member]

Hi experts!

I'm looking for a solution on how to accumulate a value, say 0AMOUNT, over time. The reason is a requirement to look att accumulated values although only posted amounts per fiscal perioid is available from the BC extractor. So the posted amounts need to be summed up over the time dimension in order to calculate a (also historical) balance for each fiscal period. How would you best implement such a solution?

I have considered:

1) define a hierarchy on 0fiscper that groups together fiscal periods into an aggregated level - e.g 2001-01 in the hierarchy would contain actual fiscper 2001-001, 2001-02 in the hierarchy would contain both 2001-001 and 2001-002 (thereby causing an accumulated value when summed up), and so on ...

2) Do the accumulation in an update routine by some ABAP code - im not quite sure on how to do this - any suggestions would be helpul!

3) Dynamically calculate the sum of 0amount in the report although this would be the least efficient soulution...

Any help/suggestions is appreciated!

Many thanks,

David

[Former Member]

Just as you say i'm also sure that it "can" be done, i'm just looking for the best solution. And possibly some hints in implementing that one.

It is true that I have 0AMOUNT per fiscal year/period, but the option to simply sum up 0AMOUNT in the report is not feasible since that would require to much computation to be done online (we keep history for a long time back). Hence I would need to precompute the accumulated value per fiscal period and save it in the cube as a non-cumulative balance. So when the user restricts on, say fiscper "2003-01" in the query, the accumulated balance for 2003-01 is directly retrieved from the cube.

Many thanks,

David

[Former Member]

Hi David,

I cannot quite understand your requirements.

You want to accumulate 0AMOUNT overtime? If you have a 0AMOUNT per fiscal period and is stored in a CUBE/ODS, I could not possibly think why the accumulation cant be done?

Pls enlighten more..

Regards,

Jkyle