Key Figure formula is not reflected in Formula / Graph View

[former_member312896]

Hello experts,

We have a calculated and stored key figure which gets its value from another key figure based on PERIODID condition. There is no error in formula and even planning area activation is success. Formula screen shot below

However values are not calculated for the output key figure. One observation is that even though we can see formula in Key Figure calculation view, Formula / Graph View does not represent the same and this could be the issue. Is this standard behavior or we are missing something?

Graph view for KF: YWPLTPDESIGNEDMAXCAPACITY

[Irmi_Kuntze]

try with $$PERIODIDCU1$$

[former_member312896]

Hi Irmhild,

Thanks for the answer, but it failed with error PERIODCU1 does not exists in planning level.

Thanks

[Irmi_Kuntze]

yeah, I always mix $$PERIODIDCU1$$ and $$PERIODID1CU$$

Does that work?

[former_member312896]

Hi Irmhild,

$$PERIODID1CU$$ was accepted in the formula but the result was same. No values populated.

Thanks

Vilas

[Irmi_Kuntze]

did you adjust for periodidto as well? They should be in line

and if that does not help, try to split the formula into pieces in different KF to identify where the error is coming fomr

[former_member312896]

Yes. periodito was also adjusted. Since there is no error in formula unable to understand where to split formula

[Irmi_Kuntze]

just test one condition after the other to narrow down the error.

Like one interims KF that ONLY checks on the first condition periodid1 - $$periodid1cu only and test the result, than test the other condition periodid1 >= $$periodid1to, and did you check that your KF YWPLTPDESIGNEDMAXCAPATIMEINDE has some value at all?

[former_member312896]

Hi Irmhild,

Looks like I am missing something on planning level here. To test it, I have created another KF at same planning level from which I need to value and same formula is working correctly. See below the new KF defined.

Can you guide what mistake I am doing while writing the same formula for target KF which has different planning level from the key figure from which I am fetching the value based on condition.

another difference is that new KF I have defined is not a stored KF.

Thanks

Vilas

[Irmi_Kuntze]

ah, I had not recognized that. You are doing a complete calculation, so the storage flag must not e set

I assume that in the request level you have the automatic set of the level yearloc as stored value, but as all is calculated and nothing is stored (even if you set this as stored) the result will be blanc

if you want to have the result stored (whyever you may need that), you need to use copy / disagg / ADVSIM operator

[former_member312896]

Thanks for the answer. Does this mean that it cannot be achieved by formula at all and we must use operator.

Thanks

Vilas

[former_member312896]

Hi Irmhild,

We can even do without stored result. But when I am trying to change this KF to not-stored. System does not allowed me. It gives the message while planning area activation as

"E - Calculation YWPLTPDESIGNEDMAXCAPACITY@REQUEST: YWPLTPDESIGNEDMAXCAPACITY@WKPRODLOC must be stored, or a calculation must exist"

Thanks vilas

[Irmi_Kuntze]

Hey Vilas

than you obviously forgot to change the storage flag in inbound KF YWPLTPDESIGNEDMAXCAPACITY on request level of YWPLTPDESIGNEDMAXCAPACITY

there is (or was, not sure if it still exists) a section on activation errors, and what kind of errors can occur in the model config guide, maybe you search for that

If you cannot adjust, just delete it, activate and recreate. But it is not difficult to adjust

As the root for your initial issue is solved, it would be nice if you close the topic

[former_member312896]

Hi Irmhild,

The point I was trying to say that, the output KF must be a stored KF and system does not allow it to be just a calculated KF.

I am closing this thread no as it looks like the only option I have now is to use operator.

Thanks

Vilas