Sap Ecc to Bi

Topics: SAP AG, Drag-and-drop, Data management Pages: 16 (3718 words) Published: April 30, 2013
Step by Step Procedure to Extract Data from R/3 to BI 7.0 using Query

Applies to:
SAP BI 7.0. For more information, visit the EDW homepage.

Summary
This article demonstrates a step-by-step process for doing generic extraction from R3 into BI using Infoset query. It also describes the creation of User Groups,Infoset query and BI objects like InfoObjects, DTP, Transformations and also includes the steps to install Objects from BI Content. Author: Vishall Pradeep

Company: Applexus Software Solutions (P) Ltd. Created on: 24.02.2011

Author Bio
Vishall Pradeep Somasundaram is working as SAP BI Consultant with Applexus Software Solutions (P) Ltd.

SAP COMMUNITY NETWORK © 2011 SAP AG

SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com 1

Step by Step Procedure to Extract Data from R/3 to BI 7.0 using Query

Table of Content
Table of Content ................................................................................................................................................. 2 Steps in R/3 ........................................................................................................................................................ 3 Step 1: Creation of User Groups (Transaction SQ03) .................................................................................... 3 Step 2: Creation of InfoSet (Transaction SQ02) ............................................................................................. 5 Step 3: Creation of InfoSet Query (Transaction SQ01) ................................................................................ 11 Step 4: Creation of Generic DataSource (Transaction RSO2) ..................................................................... 15 Step 5: Testing Generic DataSource (Transaction RSA3) ........................................................................... 17 Steps in BI......................................................................................................................................................... 19 Selecting Source System .............................................................................................................................. 19 Replicate Metadata ....................................................................................................................................... 19 Creating InfoPackage and uploading data to PSA ........................................................................................... 21 Creating InfoArea .......................................................................................................................................... 22 Creating DSO ................................................................................................................................................ 24 Creating Transformation ............................................................................................................................... 26 Creating DTP (Data Transfer Process) ......................................................................................................... 28 View contents of DSO and move data from New to Active table .................................................................. 31 Related Content ................................................................................................................................................ 33 Disclaimer and Liability Notice .......................................................................................................................... 34

SAP COMMUNITY NETWORK © 2011 SAP AG

SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com 2

Step by Step Procedure to Extract Data from R/3 to BI 7.0 using Query

Steps in R/3
Steps to create a SAP query using InfoSets. There are three main steps in writing a query. They are; 1. Creation of User Groups (Defines who is going to create, modify and use the query) 2....
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Sap Bi Essay
  • Sap Bi Process Chains Monitoring Essay
  • SAP ABAP Essay
  • Saps Essay
  • Sap Swot Essay
  • bis 221 wk 4 Essay
  • Sap Ag Essay
  • bi speech Essay

Become a StudyMode Member

Sign Up - It's Free