SAP IBP Configuration - Use the Add Time Dimension Function in SAP IBP

[Peng_Lu]

The IBP_ADD_TIME_DIMENSION function in SAP IBP is used to simplify the modeling of key figures by converting time-independent input key figures into time-dependent output key figures.

This function helps in managing and analyzing data across different time dimensions, making it easier to handle complex planning scenarios.

It retrieves and returns the value of the time independent input key figure in a time dependent output key figure.

The Parameters of the IBP_ADD_TIME_DIMENSION Function

The IBP_ADD_TIME_DIMENSION function has three mandatory parameters.

1st parameter: input key figure at input planning level (mandatory)

It can be either a stored or calculated input.

The input planning level must be time-independent, which means that it can’t have a root time attribute (not even PERIODID). 

The parameter value must be surrounded by double quotation marks.

2nd parameter: current period (mandatory)

This second parameter determines what current period is in the calculation.

Use the placeholder $$PERIODIDnCU$$n represents the time profile level that matches the time profile level of the output planning level.

You can also add a plus or a minus operator with an integer value in the expression to shift the current date. For example: $$PERIODID0CU$$ +1 or $$PERIODID0CU$$ -2.

https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/bf99e931b8d44aafb4e306ec3602cbdd/d2807f96...

Create Configuration

1. Create a key figure called CURRENTINVENTORY at the MTHPRODLOC planning level, displaying the values of Timeless Inventory Qty key figure in the current bucket.
Use the following data.

Field	Value
Key Figure ID	CURRENTINVENTORY
Base Planning Level	MTHPRODLOC
Name	Current Inventory
Calculated	X

Add the following calculation: CURRENTINVENTORY@MTHPROLOC = IBP_ADD_TIME_DIMENSION("TIMELESSINVENTORY@PRODLOC","$$PERIODID0CU$$",''CURRENT'')

using the IBP_ADD_TIME_DIMENSION function to convert the time-independent key figure TIMELESSINVENTORY@PRODLOC into a time-dependent key figure CURRENTINVENTORY@MTHPROLOC with the specified time dimension $$PERIODID0CU$$ and the time scope 'CURRENT'.

Here's a breakdown of the components:

• TIMELESSINVENTORY@PRODLOC: The initial inventory key figure at the product location level, which is time-independent.
• $$PERIODID0CU$$: The time dimension, likely referring to a specific period ID (e.g., monthly buckets).
• 'CURRENT': The time scope indicating that the function should consider only the current period.

This function will distribute the values of TIMELESSINVENTORY@PRODLOC across the monthly time buckets defined by $$PERIODID0CU$$, considering only the current period.

2. Activate your planning area.

Test Your Solution in the Planner Workspace

Test your solution by creating a Planner Workspace using the following information.

Field	Value
Time:
Time Period	Monthly
From	Current Month
To	Current Month + 12
Rolling	Yes
Attributes:
Product ID	Selected
Location ID	Selected
Key Figures:
Current Inventory	Selected
Filters:
Product ID	x100 Phone

TIMELESSINVENTORY is time-independent key figure, there is no time dimension in the key figure. 

IBP_ADD_TIME_DIMENSION converts time-independent key figure, TIMELESSINVENTORY to time-dependent key figure,  CURRENTINVENTORY. It shows the values of TIMELESSINVENTORY@PRODLOC in current period