IBP Weekly indices calculation logic

[former_member607906]

Tthere is requirement to calculate Weekly indices based on past two years sales history. The logic requested is as below:

• W1 Indices Calculation : Average ((X1W1/Sum(X1W1:X1W5),(X2W1/SUM(X2W1;X2W5)). Similary W2 W3 etc should be calculated

  This is required across the future buckets. This calculation will be required at WK/PRODUCT/LOCATION/CUSTOMER Catch is that the summation of week values should be restricted within that month

  Periodw1w2w3w4w5No. wksFinal POD qty prior 2yr (X1)2016161612Final POD qty prior yr(X2)2020202020

  Let me know any suggestion how to achieve this or any confusion with the requirement.

[former_member607906]

requirement.png

[former_member607906 · Accepted solution]

I used Copy and Disagg operator. Making my Key figure Aggregation mode as Avg and Disagg mode as Copy. I ran the operator at month level and same data were copied at weekly level as well within that month which eventually I was able to use it for my indices calculation.

[neeraj_deshkar1]

Hi Mayank,

Please try using CAGGR function released by SAP in 1905 version. You can restart the calculation at monthly level in time profile.

Regards,

Neeraj

[Irmi_Kuntze]

Well, I still dont understand exactly what you need, hence only a brief idea.

If you want more details, you need to provide a better description

With IBP 1905, we have a new operator for key figure calculation IBP_CAGGR (fully described in model configuration guide) that can do cumulation. So with it you could sum up values of a couple of periods and calculate some average. I have calculated projected stock with this, for example.

However, this operator is not (yet) able to do a rolling calculation (roadmap). That means you can calculate based on a defined starting and end point. I assume that this is not fulfilling your requirement.

However, if you had only few periods to consider for the future calculation, you may be able to work in addition with attribute transformation in combination with IBP_CAGGR

If that is not possible either, you can either wait until the rolling IBP_CAGGR is available, or you can request the build via LCode. OSS note 2298382 "Requesting L-Code from SAP" provides you the info you need to put into an OSS message you have to create, including a proper description and example in Excel best with formula in the excel

[Irmi_Kuntze]

???

Can you please share a screenshot that documents your requirement?

Are you talking about EPM or backend?

[former_member607906]

requirement.png

Need to create a key figure at backend.