Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded