Key fig(Cumulate)

[Former Member]

Hi to all,

i have a Key figs, which calculate which calucated day wise quantity (fore cast(Day), Actual(day) .

Based on above Keyfigs , i have forecast(Cumulative) and Actual(Cumulative).

what is the Problem is.

Forecast (day & cumulate) has to be calculated from begining of the month to the end of the month.

Actual(Day & Cumulate) has to be calculated from begining of the month to the Present running day.

when i am finding the Actual(Cumulative) based on the Actula(Day) keyfig, it is cumulating correctly up to runing day but after present runing day( System date), it giving default value for remaining days as last cumulated value.

i should not get Actual(cumulate) after Present runing day.

because i has to calculte Gap(Cumulate) = Actual(cumulate) - Forecast(Cumulate).

What is the solution for this?

[Former Member]

You can create a restrcited KF for actual with current calendar day (SAP Exit Variable) and use it in the query.

Regs

Gopi

Assign points if it helps ....

[Former Member]

Hi reddy,

Not sure to have understood correctly your problem.

Generally I determine these values with Selection on key figure based on Offset.

For example:

Actual Column = right mouse click on Amount --> New Selection --> "Month = SAP Variable for Actual Month" and "Day: offset on SAP Variable for actual day with <= setting for offset".

Forecast Column = right mouse click on Amount --> New Selection --> "Month = SAP Variable for Actual Month" and "Day: offset on SAP Variable for actual day with > setting for offset".

Ciao.

Riccardo.

[Former Member]

thanks for ur help.

i am explaining my senario.

Scenario like this.

Unit:- AUP.

Month:- Sep-2006.

Plant- xxxx

Production Hierarchy:- 01

Date Forecast(Day) Actual(day)Foreca(Cumu)Actu(Cumu) Gap(Cumu) %(Cumu)

1 50AUP 30AUP 50AUP 30AUP

2 50AUP 40AUP 100AUP 70AUP

3 50AUP 60AUP 150AUP 130AUP

4 ……. 20AUP 200AUP 150AUP

5 ….. ….. …… …….

.. ……… end of prese ……….. Present the runing

.. running month day d...

day(system-

End 50AUP Date) Month

of the

month

Gap(Cumulate) = Actual(Cumulate) – Forecast(Cumulate).

%(Cumulate) = Gap(cumulate) / Forecast(cumulate)

Gap(Cumulate) I calculated as ( NODIM ( 'Actual(Cumulative)' ) <> 0 ) * ( 'Actual(Cumulative)' - 'Foreseen(Cumulative)' ).

I have taken actual(cumulative) as, in new selection I dragged actual (day) and given name as asctual(cumulative) and in properties I checked cumulate option.

Here Actual(Day) and Forecast(Day) comes from infocube and Actual(cumu) and Forecast(Cumu) depends upon above keyfig.

The Problem coming here.

Actual(day) contains the value from beginning of the day to present day(System date). When I am doing Actual(Cumulate), it is cumulating the values correctly from beginning of the month to Present Day. But after Present Day(system date), by default it giving last cumulated value to all remaining days in Actual(cumulate) keyfig.

But I should get up to only Present day(system date).

Even I restricted the Actulal(cumulate) with variable ( from beginning of the month to the system date) it giving same default values.

How to rectify this problem.

[Gunter_Cokl]

Hi!

Did you find a solution?

I had similar problem with 2 KF -> one for the whole year, the other only up to actual month. Both KF cumulated, but the second KF (up to actual month) shows the cumulated value of actual month for the rest of the years monthes, too.

This is a problem for our charts.

OSS says this is the way system handles "cumulation", no solution.

So, if somebody knows a solution...

br

gunter