How to arrive at a stored Key Figure B from a calculated KF A?

[vincentverheyen]

Hi, an Additional Input can not generate Planning Objects by itself, if it is added to a calculated Key Figure.

My question is: how can you arrive at a Stored KF B from a Calculated KF A?

A copy operator would be an obvious answer. What are some scenarios where another way would be preferred, for example via CI-DS?

[avijit]

Dear,

You may explore Attribute Transformation but that would require creating additional configuration/calculation.

If the requirement is to Store value of Calculated KF A into KF B only, Copy Operator can do the job with existing configuration.

CPI DS task can upload data into a Stored Key Figure only. KF A is Calculated.

Best regards,
Avijit

[vincentverheyen]

Hi avijit, thank you. Can you confirm that:
1) It is correct that an Additional Input can only generate Planning Objects if it is a Stored Key Figure?
2) Attribute Transformation (even though it requires some additional config.) on a Calculated KF A, can equally (just as the alternative via a Copy Operator would be able to) create a Stored KF B?

[avijit]

Dear Vincent,

1) It is correct that an Additional Input can only generate Planning Objects if it is a Stored Key Figure?
--> Additional Input act like inner join / union, used for aligning Output(LHS) and Input(RHS) planning levels selected in a key figure calculation. It cannot facilitate in creating a planning object at a plan level.

2) Attribute Transformation (even though it requires some additional config.) on a Calculated KF A, can equally (just as the alternative via a Copy Operator would be able to) create a Stored KF B?
--> Not equally. While Copy Operator can create planning object and store time series values, Attribute Transformation can help in populating a key figure value without need to create a planning object / time series data.

Best regards,
Avijit