The purpose of the blog is to share different options available for building data interface from SAP FC to SAP BW or other external system.

There exists multiple options available to transfer data from BFC to external systems. The most standardized final options are listed below

1a) Cube Designer (CD) Star Schema Deployment and BODS – This solution leverages CD native functionality to create Star Schema extract out of BFC and then use  BODS features to move data to external system.

1b) Cube Designer ( CD) with BW Cube Deployment – This solution leverages CD native functionality to create BW cube directly. This functionality requires BFC and CD to be deployed in same data base as BW database. CD.jpg

2) SAP FIM  – This solution leverages native FIM  functionality that uses BFC web service to get data from BFC and then transfers data to external system.

FIM.jpg

The key considerations while selection the appropriate method for your data transfer are as follows

Evaluation Criteria Cube Designer Star Schema with BODS SAP FIM
Maintenance Custom Vs. Standard Need BODS development No Development required
Maintenance Complexity of Design Complex design, need to manage CD and BODS jobs Simple FIM jobs
Maintenance Proven Solution Proven solution Proven solution
Flexibility for future enhancement/changes Very flexible, used BFC native filters, master data for restriction. Data selections can be very flexibly controlled Less flexible. Only manual filters available in FIM. Not able to restrict data selection by master data or attributes.
Reconciliation Process 2 Step process, first to deploy cube and then used BODS for data transfer One step process
Speed of Loads Scales much better for high volume loads. Really impressive for high volume loads. Performs only well in low volume loads as web service based
To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply