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

[Former Member]

Hi,

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?

[Former Member · Accepted solution]

Hello,

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

Thanks

VenKat