on 02-14-2008 3:09 AM
Hi,
I am new to BI 7.0.
Can anybody explain me about the steps involved in extracting data from R3 to BI 7.0?
I know the steps in R3 side.I want to know how to replicate the datasource in BI 7.0 and assigning the Infosource.
Regards,
Sudheer.
Steps for extraction (This will be an overview only)
1. Log into ur R3 system
1.1) Find ur datasource by using tcode RSA5
1.2) To view the records for the particular datsource , use tcode RSA3. verify the records with your functional consultant or customer . IF any more fields are needed then use "Enhancement" strategy.
2. Log into ur BW system
2.1) using Tcode RSA1 - Locate your source system.
2.2) Find your datasource in the sourcesystem and then replicate.
2.3) Locate your Infocube or DSO , where you want to add the datsource.
2.4) I'm giving eg of Infocube : Rt Click your infocube , Select transformation.
2.5) In transformation - Source of Transformation Header , select object type "RSDS Datasource" , Lcoate your source system and then the datasource.
2.6) MAp the fields in the transformation and activate it.and load the infopackage
2.7) Correpsonding DTP would be created, Activate and execute it. The data would be loaded in the cube.
2.8) to check the data has been added in the cube , Rt click Infocube , Manage tab , and see the requests. There will be a column names "Added records". this shows records are added
Even in SDN lot of topic regarding extractiona re given.Just have a go thru.
From
Manesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sudheer -
Search in SDN. This question was discussed in forums many times.
Anesh B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the following links.
check the following
http://help.sap.com/bp_biv235/BI_EN/html/bw.htm
business content
https://websmp203.sap-ag.de/co
http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm
(navigate with expand left nodes)
also co-pa
http://help.sap.com/saphelp_nw04/helpdata/en/53/c1143c26b8bc00e10000000a114084/frameset.htm
LO Extraction
Check these links:
/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146
/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur
/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods
/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it
/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis
Also Refer this link:
http://www.sap-img.com/business/lo-cockpit-step-by-step.htm
FI-CO 'Data Extraction -Line Item Level-FI-CO
FI-GL
http://help.sap.com/saphelp_nw04/helpdata/en/c9/fe943b2bcbd11ee10000000a114084/frameset.htm
http://help.sap.com/saphelp_470/helpdata/en/e1/8e51341a06084de10000009b38f83b/frameset.htm
http://www.sapgenie.com/sapfunc/fi.htm
FI-SL
http://help.sap.com/saphelp_nw2004s/helpdata/en/28/5ccfbb45b01140a3b59298c267604f/frameset.htm
http://help.sap.com/saphelp_erp2005/helpdata/en/41/65be27836d300ae10000000a114b54/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/ee/cd143c5db89b00e10000000a114084/frameset.htm
How to do basic LO extraction for SAP-R3-BW
1. Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name.
2. Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)
3. In OLI*** (for example OLI7BW for Statistical setup for old documents : Orders) give the name of the run and execute. Now all the available records from R/3 will be loaded to setup tables.
4. Go to transaction RSA3 and check the data.
5. Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.
6. Go to BW system and create infopackage and under the update tab select the initialize delta process. And schedule the package. Now all the data available in the setup tables are now loaded into the data target.
7.Now for the delta records go to LBWE in R/3 and change the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will bypass SM13 and directly go to RSA7. Go to transaction code RSA7 there you can see green light # Once the new records are added immediately you can see the record in RSA7.
8.Go to BW system and create a new infopackage for delta loads. Double click on new infopackage. Under update tab you can see the delta update radio button.
9.Now you can go to your data target and see the delta record.
find your scenario and find what data sources do you need on R3 side and ensure they are active as well:
http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm
find your scenario -> data sources -> go to R3 -> sbiw and activate required data source
replicate data sources in BW:
RSA1 -> source systems -> right click on your source system -> replicate
then activate your BC:
service.sap.com/bi -> BI Business Content -> General Information -> SAP BW Business Content - Activation
and execute infopackage (it should be delivered with BC)
Useful links:
http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm
Pls chk this cookbook for step by step;
http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%201.pdf
http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%202.pdf
Step by step Generic extraction:
How To doc link
https://www.sdn.sap.com/irj/sdn/howtoguides
Hope this helps
Regards
CSM Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.