IBP fill key figure with values from future bucket

[DaRos]

Hi Gurus,

In IBP I have a stored key figure loaded from CI-DS. Some values missing for some periods. I.e. I have some values, then some empty buckets and then some values and then some empty and so on... I like to copy backwards (from future to past) last value before the empty zone to all null bucket. Same functionality as IBP_LAST_VALUE but from future to past.

Any idea ?

Thank you !

[Andrei_Lupu]

Hi @DaRos ,

How many empty buckets (periods) are you expecting to have? If the dimension is not very high (let's say you have 5 periods of blank values before stored values), I would suggest creating a series of helper key figures that perform negative period shifts. This manual workaround can help fill the empty buckets with the last known value from future periods:

1.  

Helper 1 KF :  IBP_PERIODSHIFT("YOURSTOREDKF@YOURBASEPLANNINGLEVEL", -1)

Helper 2 KF: IBP_PERIODSHIFT("YOURSTOREDKF@YOURBASEPLANNINGLEVEL", -2)

Helper 3 KF: IBP_PERIODSHIFT("YOURSTOREDKF@YOURBASEPLANNINGLEVEL", -3)

Helper 4 KF: IBP_PERIODSHIFT("YOURSTOREDKF@YOURBASEPLANNINGLEVEL", -4)

Helper 5 KF: IBP_PERIODSHIFT("YOURSTOREDKF@YOURBASEPLANNINGLEVEL", -5)

2.

Then I would create a calculated KF to show the final value (either the stored CI DS one (if exists) -> if it doesn't exist : display value of periodshift -1 (if it's different than null)  -> if it doesn't exist : display periodshift-2  (if it is different than null) -> etc till period shift -5 helper KF

FINALKF would look like this : 

= IF(NOT(ISNULL(YOURSTOREDKF@YOURBASEPLANNINGLEVEL), YOURSTOREDKF@YOURBASEPLANNINGLEVEL,  IF(NOT(ISNULL(Helper 2 KF@YOURBASEPLANNINGLEVEL), Helper 2 KF@YOURBASEPLANNINGLEVEL,  IF(NOT(ISNULL(Helper 3 KF@YOURBASEPLANNINGLEVEL),  Helper 3 KF@YOURBASEPLANNINGLEVEL  , etc until Helper 5 )

Alternatively, you can raise a Customer Influence request to SAP and suggest they implement an IBP_FIRST_VALUE calculation here: 

https://influence.sap.com/sap/ino/#/campaign/21/ideas

[DaRos]

Hi @Andrei_Lupu,

Many thanks for your answer.

Your solution works well for 5 empty bucket max and unfortunalety it doesn't match my customer expectations.

I like to have no limitations about the number of empty buckets and the number of set of empty buckets.

[Andrei_Lupu]

hi @DaRos,

Unfortunately, that's the only IBP workaround that comes to mind at the moment. Perhaps others in the group might have a better idea to share. CI DS (in case you are using) might be an other area to explore for handling this request.

As I mentioned earlier, in the meantime you could also consider requesting SAP to create an 'IBP_FIRST_VALUE' formula via the Influence portal.