Year to Date(YTD) / Year to Go(YTG) in SAP IBP: Cumulative Aggregation
For a Demand/Supply Planner it is very crucial to play around with numbers in their day to day life to obtain a feasible plan for production. In Most Industries Demand planning happens at the Yearly, Quarterly, Monthly Buckets. Planners would like to see the aggregated data by cumulating it to Yearly, Quarterly etc. SAP IBP provides a provision to see a Total cumulated data over the defined time period in the planning view.
The above shown aggregation allows the planner to aggregate the Total Periods defined in the Time period settings of the Planning View.
Incase if a planner wants to see the aggregation from past until the current month and so on, then it is not possible in the standard key figures. To achieve this business requirement a new key figure needs to be configured which uses the input value from the previous periods.
Until the Release of SAP IBP 1905, a custom key figure calculation needs to be defined using the cartesian join between key figure to be aggregated. Refer below Note for More details
In the latest release of SAP IBP 1905, the functionality is simplified by Introducing a new aggregation function called “IBP_CAGGR”.
Year to Date
To calculate the sum of key figure values from the beginning of the Year up to the current period (Year to Date) in One Period.
Year to GO
Similarly, we can define a calculation to calculate the sum of key figure values from the next period to the end of the Year (Year to GO).
A Graphical Depiction on Year to Date and Year to GO
The Function IBP_CAGGR is a cumulative Aggregation Function which allows to model a calculated Key Figure. The Function allows five parameters to be passed as an Input out of which 4 parameters are mandatory parameter and 1 parameter is an Optional parameter.
Parameters for IBP_CAGGR
- Input Key Figure *
- Aggregation Mode*
- Restart at
Input Key Figure: A reference Key Figure from which the values need to be cumulated, For all periods a key figure value should exist else an Empty value needs to be modified as NULL, for cumulative aggregation to determine the correct results.
Aggregation Mode: This parameter specifies what value needs to be modeled in the key figure either sum or average or minimum or the maximum.
Direction: In the above Graphical Representation Year to Date is an aggregation over a Forward direction whereas Year to GO is an aggregation over a Backward direction.
Horizon: This Parameter specifies which Horizon a function should pick to aggregate from the current period.
Possible values are: PAST, PASTCURRENT, PASTCURRENTFUTURE, CURRENT, CURRENTFUTURE, FUTURE.
Re-start at: It specifies the Time Profile where a cumulative aggregation should re-start for the Function.
Key figure calculation of Year to Date in SAP IBP
Excel Planning view with YTD aggregation
In the below example, AOP revenue values are required to see YTD for each monthly bucket.New KF-AOP Rev YTD will Aggregate the AOP Revenue values for 12 months in Foreward direction with calculation consideration of PAST to Future.
We can see the AOP Rev YTD KF-value is restart at Jan-2020 and again Jan-2021.
Things to be Considered
- The Function cannot take more than one Input Key Figure.
- The Input and Output Planning levels must be identical.
- When a calculation Graph includes a cumulative aggregation, the top most key figure in the calculation graph mustn’t be editable.
- IBP_CAGAGGR calculation will not allow more than 5 parameters defined by SAP.