Time bucket accumulation of SAP2 Standard Keyfigure "ACTUALSQTYPRIORYR"

[former_member287350]

Hi everybody,

I face a problem with the SAP2 Key Figure "ACTUALSQTYPRIORYR".

It works perfectly fine on the lowest selected time profile level (in SAP2 example: Monthly) by showing the respective Actuals Quantity of t-12 periods. However, this stored value is not accumulated correctly when the data is viewed on a higher time bucket level (e.g. "Quarterly"). This appears in SAP2 standard, the key figures have not been changed.

In the quarterly view, I would expect to see the summed up values of the respective 3 months in the last year. Instead, the Acutals Quantity of the SAME year is displayed. I will give a quick example:

Monthly View:

	Jan 14	Feb 14	Mar 14	...	Jan 15	Feb 15	Mar 15
Actuals Quantity	1000	2000	3000		4000	5000	6000
Actuals Quantity prior year	500	500	500		1000	2000	3000

Quarterly View:

	Q1 14	...	Q1 15
Actuals Quantity	6000		15000
Actuals Quantity prior year	6000		15000

So as you can see, the calculation works on the monthly level, but at quarterly level I would expect 1500 in Q1 14, and 6000 in Q1 15.

Any hints or workarounds to solve this problem?

Thanks a lot,

Holger

[Former Member · Accepted solution]

Hi Holger,

You also need to create attribute transformation for quarter just the way you would have created for month.

For month the calculation would be-

PERIODID0@perprodcust1 = PERIODID0 +12 , where input  is Actualqtyprioryr

Similarly you can add another calculation for  quarter- 

PERIODID2@perprodcust1 = PERIODID2 + 4 ,where input  is Actualqtyprioryr

and so on for year-

PERIODID1@perprodcust1 = PERIODID1 + 1 ,where input  is Actualqtyprioryr

Thanks,

Rohit