2023 Sep 26 5:30 PM - edited 2024 Mar 26 9:48 AM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
User | Count |
---|---|
5 | |
4 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.