on 12-21-2017 12:10 PM
Hi,
Need some help in configuring disaggregation expression, where sales history is used to disaggregate forecast values? Example: I want to disaggregate values of Jan'18 based on actuals qty of Jan'17.
As of now, we are trying to use copy operator to copy Actuals Qty prior year (at day level) to stored key figure at week level. So as to use the sales history in disaggregation expression of our KFs which are at week level. However, our copy operator is copying actuals qty instead of actuals qty prior year.
Thanks,
Samiksha
Hi Samiksha
Can you give us a screenshot of all KF along with input KF screen and copy operators?
Regards
Ankur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ankur,
So we have a standard Actuals qty prior yr KF (ACTUALSQTYPRIOIRYEAR), and we are using its offset to calculate another KF (HACTUALSQTYPRIORYEAR) at day level. Below are screenshots of the two:
After this we are using simple copy operator to copy HACTUALSQTYPRIORYEAR at day level to ZACTUALSQTYPRIORYEAR at week level. So as to use stored KF at WKPRODLOCCUST level in disaggregation expression. Below are screenshot of stored KF and KF using disaggregation logic.
Our issue is that when we are copying HACTUALSQTYPRIORYEAR to ZACTUALSQTYPRIORYEAR it is actually not copying offset of Actuals Qty but Actuals qty itself, which is not our requirement.
Thanks in advance!
Regards,
Samiksha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
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.