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

PROCESS:


Steps to be followed in R/3



Step 1: Goto T-code RSO2. Give the DataSource name in Transactional data (as we are uploading transactional data) and click on Create

Step 2:

1.Specify the Application Component name

2.Fill in the text column with meaningful description

3.In “Extraction from DB view” give the table/View name from which you want to extract data.

4.SAVE

Note: Click on F4 to chose Application Component name

Step 3: Clicking on SAVE will lead to the below screen.

Note: We can do “Selection”, “Hide” the fields etc as shown in the below screen shot

Step 4: Go to T-code RSA6 to know if the DataSource is successfully activated

Note: Only Datasources which are activated will be displayed in RSA6 transaction

Steps to be followed in BI

Note: The RFC connection should be configured before you replicate data to BI system

Step1:

1.Goto RSA1 => DataSources

2.Rtclk on Sales and Distribution tree => Replicate Metadata 3.Activate

Step 2: Once the DataSource is replicated, you get a below popup, we need to choose “as DataSource” as we are using BI 7.0

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

There you can see status – “Request successfully loaded to PSA”then the data is 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

Step 8: Create DTP

DTP: DTP is used to transfer data from PSA to Data target. In our case the target is InfoCube.

There we can show the Source and Target DTP

Note: In our case the source is DataSource and Target is InfoCube

Select Extraction Mode as “Full” as we are loading the data for the first time

Step 9:

1.Save and Activate

2.Go to “Execute” tab and click on Execute

Below screen shot shows the DTP monitor. Green indicates that the data is successfully loaded to the target system

Step 10: To see if the data is successfully loaded to target system,

Rtclk on the Infocube => Manage

Note: When you create DTP a Request Id will be generated as shown in the below screen shot

Step 11: Go to “Contents” => “InfoCube Content” to see the output