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

Extracting in FI and CO

Dear Friends,

During the process of blueprinting the ETL process in BW for FI and CO, i have seen that there are many InfoCubes in the business content for a same area (for example in Controlling Analysis for CCA there are about 5 Infocubes). How do we know what is being used in SAP R/3 so that we can activate on the relevant InfoCubes and their datasources. Thanks for all the help in advance.

Mike

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Mar 24, 2006 at 05:05 PM

    Hi Mike,

    If you see the 5 cubes (as an example here) they are for storing different types of data. The most commonly used CCA cube is 0CCA_C11. Also it is recommended not to use 0COOM_C01, which has been replaced by 0COOM_C02.

    I think it would be good to understand the different data and reporting with each cube and talk to your business to see what exactly they are looking for. Eg. If you mention statistical key figures for cost center accounting (cube 0CCA_C03), you will be able to know if that data is important for them, and something that they would like to analyze.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 04:52 PM

    If you want to do it the first time you have to install business content from RSA5 in SAP R/3 as well. Then setup data flows on BW side.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 04:53 PM

    dear Mike,

    check bi best practice ?

    http://help.sap.com/bp_biv235/BI_EN/html/bw.htm

    http://help.sap.com/bp_biv235/BI_EN/html/BW/ControllingAnalysis.htm

    http://help.sap.com/bp_biv235/BI_EN/html/BW/CostCtrPlan.htm

    http://help.sap.com/bp_biv235/BI_EN/html/BW/FinancialAccounting.htm

    also try type in infocube name in help.sap.com with 'search documentation' and option 'sap netweaver', you may get the datasources name in r/3.

    hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 06:24 PM

    Thanks to you all very much for the information. Bhanu, thanks a lot for the prompt help. I now know the roadmap to proceed. 😊

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

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.