Skip to Content

SAP IBP - Key Figure Data load at aggregate level

Oct 13, 2016 at 03:51 PM


avatar image
Former Member

Hi Experts,

I have a KF "SBU Input" defined at PERPRODCUST base planning level.

This KF is editable in nature. Users are expected to input the data manually at an aggregate level of SBU (attribute of Customer) and Product.

However the existing data volume is huge and this data is already available in an excel file. It is a tedious job for users to input all the data manually.

Is it possible to do an automated load of the data at this aggregate level of "Period-Product-SBU". Data is not available at the granular level of "Period-ProdID-CustID". Is there any work-around?

Thanks in advance.



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

1 Answer

Best Answer
Alecsandra Dimofte
Oct 14, 2016 at 06:50 AM

Hi Paul,

Aggregate data load is possible only for time dimension.

In your case I would configure an intermediate Key Figure on Period-Product-SBU planning level where I would load data. Then with the help of a split factor I would bring this data into the Key Figure available on Period-ProdID-CustID. (chapter 17.10 config guide)

If changes on aggregate level are not supposed to be reflected in real time on the most detailed level, you may consider using a DISAGG copy operator. After each data load a copy operator will run, copying and disaggregating the data. (chapter 10.8 config guide)



10 |10000 characters needed characters left characters exceeded