Cloud based Advanced Planning technologies such as SAP IBP require data integration both into and out of ERP platforms, BI Systems and other 3^rd 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

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