Sample Planning Area Activation Failed

[jeffreybeaudin]

RDS 2108 – Sandbox

Tried to activate the planning area

All Key Figures associated with the planning aggregation (ZESIPGROUP) failed?

I'm new to IBP, working in a sandbox on version 2108. Initially setup all processes and ran all scripts for RDS, everything worked, now I'm trying to setup my business model.

picture8.pngpicture7.pngpicture6.pngpicture5.pngpicture4.pngpicture3.pngpicture2.pngpicture1.png

See attached,

Thanks Jeff

[jeffreybeaudin]

In this example they plan at the yearly level by Business Unit (ZESIPGROUP) so I have all of my key figures tied to this Base Planning Level. The 1st page of the word document I sent you shows the time attributes available.

They actually have three selections in "Flexible Planning" ZPROJMGR (1st selection), ZESIPGROUP (2nd selection) and VRSIO (3rd selection), everything else is a attribute or key figure. I'm trying to migrate them from Flexible Planning to IBP - SAP sold them this solution?

RDS has a Cell phone example which is not much help, they don't do anything less than Monthly throughout the process and this first step is yearly, which is why my time series is M/Q/Y.

[jeffreybeaudin]

Modified all formula's to exclude SUM ( ).

Now fails for:

Diagnosis

In calculation ZPREVYEARS@REQUEST, the output planning level must contain all attributes from the input planning levels.

Procedure

Edit the ZPREVYEARS@REQUEST calculation, so that the above condition is fulfilled.

The formula for Previous Years is:

ZPREVYEARS@REQUEST = "ZPREVYEARS@ZESIPGROUP"

ZESIPGROUP is may Planning Aggregation Level:

Base Planning Level: ZESIPGROUP


ZPREVYEARSZPREVYEARSZESIPGROUP

Thanks again

[AyanBishnu]

In order to use multiple KFs in the request calculation, you need to keep in mind that the attributes of the output PL muse be a superset of the attributes that are used in the base planninng level of the input KF.

for example let say that the base PL of the ZZRQDLENPR KF is WKPRODLOCCUST. So in that case the base PL of the KFs ZZRQYRENPR" and "ZZADCOSTYR" must have equal or less no of attributes that exists in the WKPRODLOC PL.

In case the base PL of the input KFs have more attributes than WKPRODLOC, then you have to define calculation at WKPRODLOC level and then use addtional KF to have the input values at a KF that belongs to the WKPRODLOC PL.

Hope this helps

[jeffreybeaudin]

It's "ZZRQYRENPR@REQUEST"*"ZZADCOSTYR@REQUEST" instead of plus, I also have some that are plus instead of multiplying.

I'll try it thanks and regards,

Jeff

[jeffreybeaudin]

The error is "Calculation ZZRQDLENPR@REQUEST is an aggregation. It must have exactly 1 input KF." so I assume I'm not allowed to add a formula which comes from two other key figures to create this key figure based on your input above?

The Calculation is as follows:

ZZRQDLENPR@REQUEST = SUM("ZZRQYRENPR@ZESIPGROUP"*"ZZADCOSTYR@ZESIPGROUP")

ZESIPGROUP is my aggregation level, but these key figures also exist individually, e.g. ZZRQYRENPR@REQUEST

[AyanBishnu]

you cant use SUM operator for this. Instead just use the below

ZZRQDLENPR@REQUEST = "ZZRQYRENPR@REQUEST"+"ZZADCOSTYR@REQUEST"

[jeffreybeaudin]

It's in the attachments, can you see them?

[AyanBishnu]

Hello jeffreybeaudin

Please share the error details that you are getting while activating the planning area also share better screenshot of the KF calculation as those are not visible while zooming.but it seems like you are using the SUM operator with 2 different input KFs from different planning level. .Sum works for aggregation purpose and you can use only the same KF andf single KF at the request level using sum function.In case you want mutiple KFs in request level calculation use KF1@request = Kf2@PL1 + KF3@PL2, something like this.hope that helps