A planner’s Excel sheet loaded to SAP IBP using CPI-DS

Posted by Steve Rampton on 06-Jul-2018 07:05:01

In our experience, most customers have planning data held on spreadsheets, with e.g. ProdLoc or ProdCust by row and a time dimension in each column, similar to the view below;

But! In order to send the above forecast data into SAP Integrated Business (IBP) via Cloud Platform Integration – Data Services (CPI-DS), there can only be a single row per time period, similar to the view below (note that the data is loaded in to a staging table prior to committing to the HANA database);

Obviously such manual reformatting of data every time a load is required for SAP IBP is a waste of planner time and effort.

 

Read Article

Topics: Integration Services, SAP IBP, CPI-DS