To upload Sales Order data from SAP R/3 to BI using generic DataSources

...Previous

Step 3: Create InfoPackage on the DataSource  

InfoPackage: It acts as a link to extract data from Source system and gives it to PSA 

 

Note: We can restrict data in “Data Selection” tab once you create InfoPackage as shown in the below screen shot 

Step 4: Goto “Schedule” and click on “Start”  

 

Step 5: Click on icon “Monitor” on the toolbar to view if the data is successfully loaded to PSA  

PSA: Persistent Staging Area is a staging area where you can load the data temporarily before loading to target 

 

In the below screen shot, you can see status – “Request successfully loaded to PSA

 

Below Screen shot shows the data loaded to PSA 

 

Steps to build the Target system 

Step 6:

  1. Rtclk on the DataSource, clk on “Create InfoCube

 

Step 7: Create Dimension table. Dimension table will have all “Primary Keys”. In our example VBELN – Sales Doc No is the primary key 

 

 

Note: We need to define at least one KeyFigure

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image