Data Integration with SAP IBP using SAP CPI-DS

Posted by Suresh Sellaiah on 05-Dec-2019 11:21:21

Cloud based Advanced Planning technologies such as SAP IBP require data integration both into and out of ERP platforms, BI Systems and other 3rd party systems. 

Data integration covers both Master Data and Transactional Data. Certain data sets such as BOM’s and Routings have more challenges due to the complexity of the underlying data.

Read Article

Topics: Integration Services, SAP IBP, Integrated Business Planning, CPI-DS

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