Good day Gurus!
Can anyone provide some insight into best practices for how to best handle MOQ split between more than one location? We currently have been using one LOCID for which we map specific level 2 locations (plant) to that LOCID. We are cu...
Good day,
Our business users are looking for a way to manage editability permissions for one of our forecast key figures. The requirement is to have the first three months in the planning horizon (current + two) locked with the exception of the fir...
Hello Gurus!
I've seen a few posts on this topic but most have been unresolved or are slightly different than our requirement.
Here is a summary of our requirement and actions taken thus far:
1. KF1 exists at planning level PRODLOCCUST
2. Th...
Beginner trying to understand better how key figure calcs work; the model config doesn't go into too much detail about this.
This question seems simple but I suppose I am overcomplicating my thought process.
Say I have:
KF1@REQEST= AVG(KF1@MTH...
Hello,
I have a requirement from our business to create a new key figure (KF1 for example) that has two conditions.
1. If my current period PERIODID3=$$PERIODID3CU$$", then have KF1 = KF2+KF3+KF4+K5-KF6-KF7
2. Else if period > than current peri...
Hi zoransto,Did you ever resolve? I have the same requirement and my disaggregation expression appears to only work with '99' instead of using KF1 in the disaggregation expression. Thanks,Z
Hi Ayan,I was testing again today and the disaggregation expression is not working if it looks like this:IF("LOCID" = 'A', KF1, NULL).But it does work if I use integer value instead of KF1, example IF("LOCID" = 'A', 99, NULL).I saw another post where...
Hi Ayan,I was able to use attribute as key figure and then copy into key figure with same planning level as KF1 so that I could reference the MD attribute in disagg expression. All is good now thank you so much for you assistance!Z
Thank you ayanbishnu1981! It seems to be working now after I initialized the key figure again with all "1" values when LOCID = 'A'.Is there a way I can initialize KF2 to = '1' if LOCID = 'A' automatically at definition level rather than upload key fi...
