cancel
Showing results for 
Search instead for 
Did you mean: 

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

vincentverheyen
Active Participant
0 Kudos
768

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

Bob_Gillham
Explorer

V.,

If I understand correctly you need the values from calculated key figure A to be in a stored key figure B. With that understanding, a copy operator profile is the most straightforward and simple but not the most dynamic depending on your use case. CI-DS could be used but is also not dynamic and has more technical "overhead" than the copy operator.

I am not aware of any other methods to provide the result you are looking for. I will keep monitoring to see if any of the experts you find here can provide a more creative answer than mine.

Good luck!

Bob

vincentverheyen
Active Participant
0 Kudos

Hi bobgillham1, thanks. What about Attribute Transformation?

Bob_Gillham
Explorer
0 Kudos

I agree with Avijit that the attribute transformation path is not the most direct route. It can be explored but will most likely not provide what you are needing and would require the additional config.

guglanigaurav1987
Product and Topic Expert
Product and Topic Expert

Hi Vincent,

In IBP, Planning objects are only generated when you save 'Time Series' values for a Master Data combination present in IBP.

This can be done using the MD workbook, CI DS or a copy operator.

Using the Additional Inputs Feature, You will see the Calculated key figures values in the Planning View but please note that they don't exist as planning objects in the system and what you are seeing are 'on the Fly' values.

To create Stored KF from Calculated Values, Copy Operator is the option available to you.

Thanks
Gaurav

avijit
Product and Topic Expert
Product and Topic Expert

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
Active Participant
0 Kudos

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
Product and Topic Expert
Product and Topic Expert

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