Skip to Content

Can current bucket kF data be comparable with a KF data in other buckets

Aug 31, 2017 at 01:19 PM


avatar image
Former Member


In this scenario I have two KF namely KF1 and KF2. Data are available from current bucket onward.

I am trying to compare the current bucket data of KF1 with KF2 data(of any other bucket except current bucket)

Is it possible to implement in IBP to refer a particular bucket's data?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Sep 01, 2017 at 05:16 AM


Below are the 3 ways to do it.

1) You can achieve that through 'Local Member' Key figures. The only catch here would be, those key figures will be local for your Excel Planning view. Neither you can plot Analytics on Fiori nor there will be a trace of it on HANA DB.

2) You can achieve it through 'L Script' in the Key Figure calculations. For this you have to reach out to SAP where the SAP will do the coding based on your use-case and might charge you a bit

3) If you can identify a pattern in the time bucket comparison, you can achieve it through Helper Key figure and PeriodID's. Below is the sample approach

Create a helper Key figure called HKF.

Now write the Calculation for the helper KF that,

HKF@Day = If((''$$PeriodCU$$'' - ''PeriodID0'' = 2), "KF1@Day", 0)

Now that you stored your desired time bucket Key figure value in an exclusive KF, you can play with that



10 |10000 characters needed characters left characters exceeded