Generic Extraction based on a View – Part 2
This is Part 2 of the Generic Extraction. Part 1 detailed about the steps to be performed in ECC. You can find it here http://scn.sap.com/docs/DOC-32025
Steps in BI
1) Replicate the DataSource from the Source System. Go to T code RSA1.
Select DataSources under Modeling tab and choose the source system connectivity.
Go to SAP–>SAP Application Components–>Choose the suitable application component, Sales & Distribution in our case, and
Select create object in BI as DataSource (RSDS) when prompted.
Now the DataSource gets replicated.
2) Creating InfoPackage.
Double click on the DataSource to view the fields.
Context Menu on the DataSource and create the InfoPackage
Here you can see that in the ‘Data Selection’ tab page, you get VBELN which was selected in the ‘Selection’ option in the DataSource in ECC.
In the ‘Schedule’ tab page, make the following selections
In the Monitor screen, once the load is successful, we can see that it fetches 34,199 data records to PSA.
In PSA Maintenance you can view this records.
Once the records are successfully fetched to PSA, we can go for BI content installation of InfoObjects, and then mapping. (continued in Part 3)
Thank you for taking time out to go through the document. Hope its been helpful.