on 2020 Nov 06 5:34 AM
Hi all,
Is there a straight-forward way to copy a value sitting in current period into future periods (same KF) ?
Advanced Copy Operator / Copy and Disagg don't seem to handle this requirement.
Also Attribute as Key Figure may not be an option per business requirement.
Thanks,
Request clarification before answering.
If you need the value as calculated, the suggested solution is smart. Downside: You get a filter block regarding the periods, which depending on what you plan to do with this KF might have negative performance impact.
If you need the value stored because e.g. you just want to have a prefill and you want to manually overwrite later, then you could create a statistical FC operator and use a constant model with history = only current period, and future = all desired horizon. Downside is you need to execute a job in order to see changes, it takes additional space on the data base, and you get a lot of superfluous business logs
Best solution depends on business requirement behind the technical question 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Irmhild,
thanks for your explanation. My requirement is to calculate the avg of one key figure using only the next 4 weeks. I'm currently doing this with IBP_RAGGR function. Then I need to use that value as disaggregation factor for another key figure for the full horizon. The avg is getting recalucalted every week. I already thought about using a forecast operator. Do you think that approach fits more to my requirement?
best regards
Bastian
| User | Count |
|---|---|
| 9 | |
| 6 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 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.