Sap Ecc to Bi

Only available on StudyMode
  • Download(s) : 8
  • Published : April 30, 2013
Open Document
Text Preview
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....
tracking img