Cycle found in the calculation chain of the key figure - SAP IBP

[gaurav_guglani87]

Hello,

While trying to you the previous bucket's value of the same key figure in a calculation using either attribute transformation/RAGGR/CAGGR or PERIODSHIFT calculations, I get an error 'Cycle Found in the calculation chain.

Any suggestion on how to use previous month's key figure value in the calculation without using any Copy operators, please let me know.

Thanks

Gaurav

[piyush_parekh]

Hi,

If target key figure is used again in any of the calculation chain, it leads to the mentioned error. Can you share sample illustration of what you're trying to achieve?

Regards,

Piyush

[gaurav_guglani87]

Hi Piyush,

There can be multiple use cases of this but i am illustrating one below.

What I am trying to achieve is 'Net Requirement Calculation' for a period which is as follows:

Net Requirement Qty(Period)/Replenishment Qty = Forecast QTy(Period) - Opening STock(Period)

Opening Stock Period (Period) = Closing Stock(period - 1).

Closing Stock(period - 1) = Net Requirement Qty/Replenishment Qty(Period - 1) + Opening Stock(Period - 1) - Forecast Qty(Period - 1) .

A forecast Rollover calculation would also require a similar calculation.

In APO, we could easily do it using macros with mention of time buckets in it but in IBP, we cannot perform such calculations in real-time. ( Change on replenishment Qty based on the change in the forecast ) as we get the error i mentioned.

I can write a copy operator to perform that period shift but that is not acceptable to the planners to run it each time they want to change anything.

Let me know if there is some way of doing this without the copy operator.

Regards

Gaurav

[AyanBishnu]

Hi Gaurav

Thier is way to break the cycle without using any operator Please ping me on linkedin and we can talk. its hard to explain here

[piyush_parekh]

Hi gaurav_guglani,

You can utilize IBP_CAGGR for mentioned use case. The similar calculation is provided by SAP in model configuration guide. Please check.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2202/en-US/adbc9b3674544184936e4029f642...

Regards,

Piyush

[gaurav_guglani87]

Hi Piyush,

Thank you for the suggestion. I have tried this approach earlier but it still does not solve the problem. When you try to use this projected stock to calculate 'Required Qty' for the next bucket, It ends up giving the same error.

Let us say , in the same example, you want to make the ' Projected stock' as 'INIT Stock' of the next bucket and use it in the calculation but system will throw the error i am talking about.

Regards

Gaurav