Skip to Content
author's profile photo Former Member
Former Member

BCS Datastream vs. classical BW transformation

Hi BCS Experts,

We are using SAR ECC, SAP BW and SEM-BCS in Project.

There are 8 companies in this organization.

Consolidation units are "Company" and "Segment".

Sap ECC GL Accounts and BCS Positions are mapped. (These mapping are same for all 8 companies and for all segments)

Segment-Partnersegment mappings are also available

Partnercompany information is derivable from SAP ECC.

So I load the data from ECC into SAP-BW in a DSO (I derive all consolidation relevant infos, Partnersegment and partner company, cons. segment, cons. company into BW DSO) then I should load the data using datastream in BSC Infocube according to technical documentation.

Actually I would like to use classic BW transformation with infosource etc. to load the data into BCS Cube with delta mechanism.

Can you tell me why should I use data stream instead of classic BW transformation?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 22, 2008 at 02:28 PM

    Loading through datastream or flexible upload in BCS task ensures the breakdown category rules are adhered to and there is no missing or unwanted subassignments. Otherwise, there is risk of data inconsistencies and inaccurate consolidation results.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Cyber,

      It's not so straightforward (path 1 or 2) for me. Several years already I'm doing (including the all other BCS stuff) some other BW (to BCS) improvements and enchancements. And, frankly, I do not see a meaning in the thread topic: BCS Datastream vs. classical BW transformation.

      My answer is:

      - there is no contradiction

      - do as many BW transformations as you (and your client) wish - they (transformations/transfer and update rules) prepare the proper data and do not affect the SEM-BCS performance.

      - load data into the staging (not ODS/DSO) cube for reading from this cube to the BCS totals cube.

      - use the modern reading from a staging cube (datastream) to the SEM-BCS.

      Invite the professionals!

      Glad to see another answered question in the forums!

      Edited by: Eugene Khusainov on Dec 23, 2008 10:47 PM

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 11:28 AM


    BCS has inbuilt mechanism to assign seperate posting level to data loaded using data stream.

    Posting level 00 is assigned to data stream upload of Reported Financial data. This posting level information is interally used in BCS functinality.

    Best Regards,


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      It is possible to to delta upload using data stram approach of BCS. It is quite standard one.

      Yes, it should be possible to do inter-unit elimination (provided configurtion is there for it and proper flagging of trading partner is there)

      When we follow BCS standard approach of data collection, the steps are:

      -Data collection of Reported Financial data ( posting level 00)

      -Adjustment to reported financial data/Standardizig entries (posting level01/10)



      ---Currency Translation

      ---Interunit Elimination ...and so on

      You should strongly lookinot reaosn why you do not want to use data stread provided by BCS, I would recommend this to save from lot of other issue like inconsistency etc.

      Best Regards,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.