Dynamic aggregation of key figures in SAP-IBP

[former_member639000]

Hi All,

We want to add the future 5 period values of a Key figure and store it in another key figure.

For ex-

The sum of values from M1 to M5 in KF1 ( 10 + 20 +30+40+50 ) needs to be stored in M1 of KF2

Subsequently , M2 to M6 values of KF1 ( 20 to 60 ) needs to be stored in M2 of KF2 and so on( Screenshot attached for reference ).

Thanks,

Bibhu

[Gaurab · Accepted solution]

Hi Bibhu,

IBP_RAGGR function - to configure rolling aggregation in one step, please refer sneak preview of release 2002.

Example

AGGREGATEDDEMAND@PERPRODLOC = IBP_RAGGR ("DEMAND@PERPRODLOC" , "SUM" , -1 , 3 , "PASTCURRENTFUTURE")

[riyazahmed_ca2]

Hi Bibhu,

Requirement is very customized. Logically there are only 3 solutions.

1) Create 4 stored keyfigure each specifies the shift of the period. Create 4 Copy Operators to copy Source KF data into shift keyfigures with PERIOD_SHIFT. Target KF would be a calculated KF which has sum of Source KF and shift keyfigure in each planning bucket. The results will not be real time with this procedure and you will see appropriate increment in KF count.

2) Create attribute transformation with appropriate KF as suggested before. Results would be real time, but KF count with attribute transformation would go high.

3) Use CPI-DS to achieve the same. Extract Source KF data from the planning area. Make required transformations that involves addition of shift based calculation. Then export data back to IBP's Target KF. Results will not be real time, coz we need to trigger the flow everytime we change the data. But KF count will not increase.

I suggest 2nd or 3rd suggestions to be handy..

Regards,

Riyaz

[former_member639000]

Hi Riyaz,

1- Cumulative Aggregation- I have tried but it doesnt work as there is no boundary to stop the aggregation ( like after 5 weeks or 6 weeks)

2- Attribute transformation- It is possible through this but it involves creating a lot of intermediate KFs. Its feasible if you want to add for next 5 or 6 buckets but if we increase the buckets, the KFs increase a lot which is cumbersome.

Thanks,

Bibhu

[riyazahmed_ca2]

Hi Bibhu,

I think you can make use of Cumulative Aggregation or Attribute Transformation Functionalities of IBP.

1) For cumulative aggregation, You can try using IBP_CAGGR function. Not sure how much it is going to help for such requirement

2) Attribute Transformations may resolve your query. Add Calculations in attribute transformation as below. KF2@PL = KF1@PL + KF1@PLOFFSET1 + KF1@PLOFFSET2 + KF1@PLOFFSET3 + KF1@PLOFFSET4

Please check and confirm whether it resolves your query.

Regards,

Riyaz

[former_member194529]

Hi Bibhu,

Have you checked if the 2347105 - Master Note for the Configuration of Sample Models contains the solution for your requirement?:

https://launchpad.support.sap.com/#/notes/2347105

Best,

Ivan

[former_member639000]

Hi Gaurab,

Thanks!! This functionality will help a lot.

Any SAP Link to go through this function?

Thanks,

Bibhu

[Gaurab]

Hi Bibhu,

Here is the link , sap help sneak preview .

https://help.sap.com/viewer/58f5db44d4f047e0b60cf4cdb45b76cc/2002/en-US/7addc2dbe49149d6b116b73f29b9...

Thank you,

Gaurab

[former_member639000]

Hi Ivan,

I went through various documents in the note but none of them gives any solution to my requirement.

Thanks,

Bibhu