KF calculation

[Former Member]

Hi All,

Is it possible for a KF (e.g. Total Demand) to have one macro in first Planning Book and other macro in second Planning Book.
To explain further -- I want to calculate the value of KF --'Total Demand' adding KFs -- KF1, KF2 and KF3 in one Planning Book.
In other Planning Book-- 'Total Demand' is adding KFs -- KF1, KF2 only.

Is it feasible ? Thanks for all pointers...

[former_member187488 · Accepted solution]

As Emani said, of course you can. But for the mentioned key figure, it is an auxiliary key figure instead of liveCache key figure, which means it will never be saved in any database or liveCache. So there is no "overwrite" problem for such key figures, and no inconsistency will be caused. The only problem is, you'll get different planning result in heuristic or optimizer with the two data views.

[satish_waghmare3 · Accepted solution]

Hello Ada,

Are you saying Total Demand is an auxiliary key figure, please confirm.

I checked in the my SCM 7.0 system, it is time series key figure created based on standard infobject (9ADMDTOT).

Please help.

Thank you

Satish Waghmare

[emani_raghavendra · Accepted solution]

Hi Satish

Here Ada must be reffering to the Total Demand Key figure in SNP Planning book and it is a auxilliary key figure.

Thanks,

Emani

[former_member187488 · Accepted solution]

Exactly Emani

[emani_raghavendra]

HI,

Yes it is possible. Macro's are Data view specific. So, you can diff macros as said above.

But, the latest run macro will over write the values in Key figure if run for same selection ID and in that case it may cause inconsistent values.

Thanks,

emani