IBP Customer Source CRATIO

[willsuus]

We currently calculate the CRATIO from within APO (based on consensus fcst over a 2 year period) to load into IBP.

If we are going to try to move from APO entirely into IBP, is there a way to set the CRATIO from within IBP (i.e. no MDT load)?

[Irmi_Kuntze · Accepted solution]

Hi Susan

You can calculate a ratio using IBP_CAGGR, if you want to have one value for all periods, or IBP_RAGGR (rolling) if you want to have it time-depending, check model config guide --> simplified key figure calculation

If it shall be time-independent, do not use CRATIO but the key figure CUSTOMERRATIO and set the attribute RATIOTS to value X

Alternatively, you might use the Weighted Average function.

_____________

If you want to really fill CRATIO, you could then build a data flow with CI-DS to download the KF value from the one period you calculated into file and upload into the attribute.

Making this attribute an attribute as key figure does not help as the value in the algorithm is read from the attribute and not from the key figure value.

If you would be happy enough to work in segments of let's say 5%, you could use segmenation functionality and maintain segments or every 5% reading the KF value and write with that into the attribute.
Example:
0% --> 0
>0 and<=5% --> 5
>5 and <=10% --> 10
...
But due to this very crude rounding here, the sum of all will not always end up with 100%. It is the only workaround beside using CI-DS-loop I know

If you find a better solution, I would appreciate if you post it here

Irmi

[willsuus · Accepted solution]

Thank you, Irma. If I would use customerratio, how does the heuristic know not to use the MDT CustomerSource for the value?

[willsuus · Accepted solution]

And, does the MDT Customer Source still have to be populated? What would this be populated with if you are working solely in IBP?

[willsuus · Accepted solution]

Last question, do you have a link to instructions on how to setup CI-DS to download the file from IBP?

[Irmi_Kuntze]

If you use CUSTOMERRATIO, that is a key figure and you do not need CI-DS down-/upload. That would only be necessary if you want to calculate a value for an attribute and set that value.

You just do your calculation in the key figure itself. Then the entry for CRATIO does not matter - but you have to set RATIOTS to X, as described above. Check here for the description of the attributes