BI to BCS data interface

The goal of this project was to automate data transfer of various sales, production and stock related figures – which were available in the BI cubes – into the SAP BCS consolidation system used by the corporate controlling department. Previously controllers of the subsidiaries have uploaded this type of data in form of excel files manually.

I have implemented an extraction framework, which will execute queries in the background and provide the data as a BW datasource. The data is then mapped from key-figure model to account based model and written into an infocube, from where it can be taken over using the “load from datastream” function of SAP BCS.

The automatic transfer not just saves a lot of time and manual work for the controllers, but also increases data quality and eliminates the risk of data being tampered manually.