SAP IBP Key Figure condition for fix value

[atmadjer]

Hi IBP Expert,

I was wondering if it is possible to have "If" condition in the Key figure calculation to check if the figure is fixed or unfixed.

For example, if it is "not fixed", then we will copy the value to another key figure similar with the "isfixed" check in APO macro. What would be the attribute to check fix or unfix in SAP IBP?

Thank you very much for your help.

Cheers,

Erwan

[lokesh_reddy4 · Accepted solution]

screenshot1.png

screenshot2.png

screenshot3.png

screenshot4.png

Hi Erwan,

The below approach can achieve your requirement.

1) Enable fixing in KF1

2) System will generate two technical key figures when KF1 is enabled fixing.

3) Use the technical key figure in KF2 definition

Screenshot1: I have enabled Fixing in KF1

Screenshot2: Two Technical Key figures were generated

Screenshot3: Define Expression in KF2--Use Technical key figure in KF2 definition at calculation level

Screenshot4: In the Planning view, Values from KF1 which are not fixed got copied to KF2.

Attached screenshots.

Please let me know if this works.

Thanks and Regards,

Lokesh

[atmadjer · Accepted solution]

Thanks for your detailed help Lokesh. It will solve my issue.

It is appreciated.

[lokesh_reddy4]

HI,

1) Create Z-Attribute

2) Define an 'IF' condition in the key figure.

If Zattribute is marked with value let say "x" then populate the same key figure values else populate other key figure values.

In this case, Z-attribute can be used as fixing.

For business flexibility, you can try Attribute as a Key Figure option. (then the value of Zattribute should be numerical.)

Let me know if this works for you.

Thanks,

Lokesh

[atmadjer]

Thanks Lokesh.

My question is "what is the SAP IBP standard attribute to check if key figure is 'fixed' or 'unfixed' status".

I would like to copy the value only when the Key figure is 'unfixed'.

In SAP APO, we can check using the condition If KF ISFIXED = 0 (false).

Do we have similar condition "Fixed" and "Unfixed" KF in SAP IBP?

Hope it makes sense.

Cheers,

Erwan