Preview

Sap Ecc to Bi

Powerful Essays
Open Document
Open Document
3718 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sap Ecc to Bi
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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Nt1310 Unit 3 Review Questions
    • 464 Words
    • 2 Pages

    Nt1310 Unit 3 Review Questions

    The company is reengineering the company’s Intranet/Information systems and enterprise resource planning (ERP) system. The upper management has chosen to implement SAP to connect all aspects of the company; accounting, manufacturing, aircraft services, supply inventory, and customer resource management (CRM). Implementing this new information system (IS) will allow the different parts of the company to operate as one, by allowing the various modules in SAP to communicate and exchange data. SAP will replace all of the outdated and splintered software the company currently uses by allowing easier communication between the departments and the programs that are used. The change was started about three years ago and will be completed in about two years for a total of five years to complete and be fully implemented. Connecting all of the different departments will save a tremendous amount of money for the company. Reengineering the IS systems will allow the sales department and customer representatives more easy access to the customer’s information, such as current and future orders, current aircraft service status or new aircraft delivery time; thereby increasing the customers value and customer…

    • 464 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Business Intelligence Sysco
    • 531 Words
    • 3 Pages

    Business Intelligence Sysco

    What is BI software? What are the business benefits of BI software? What are the two alternatives for buying BI software at SYSCO? What are some implementation pitfalls of BI software at SYSCO? How should SYSCO judge the success of its BI software implementation? Is BI likely to provide SYSCO with a competitive advantage? Sustained competitive advantage?…

    • 531 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Sap America Case Study
    • 1429 Words
    • 6 Pages

    Sap America Case Study

    In 1972 SAP was founded by four young software engineers who had come up with a concept for an integrated software package, and their current employer turned it down. This initial idea sparked their first major enterprise information systems product. This took their company public, and after five years SAP’s market capitalization was $15 billion. The expansion that occurred began in Walldorf, Germany where SAP was founding and spread to the America Group. This began in the late 1980’s and was crucial to the SAP’s growth. Once their overseas group took off, there were many elements of their business that needed to be altered and improved to account for their growth. Although they began as a product based company it was very clear to everyone involved that taking care of the client, through implementation and support was crucial to differentiating themselves from competitors within the market, and a key to their survival. The development of an industry strategy was another crucial action that paralleled the growth and support of SAP. This vertical industry strategy was to be delivered through industry centers of expertise (ICOEs), which to serve as a bridge between R/3 customers and the product development organization. This partnering was the key to SAP’s consistent growth, by using the manpower of outside and inside consultants.…

    • 1429 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Student Financial Aid
    • 700 Words
    • 3 Pages

    Student Financial Aid

    ensure that you will meet the SAP requirements. Please attach your typed statement to this form.…

    • 700 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Installation SAPGUI For Windows For V720
    • 1473 Words
    • 8 Pages

    Installation SAPGUI For Windows For V720

    At this time go ahead and “Next”, and follow the instructions to install the SAP Client:…

    • 1473 Words
    • 8 Pages
    Good Essays
    Read More
  • Good Essays

    Running Shoes Fit Matters Most
    • 646 Words
    • 3 Pages

    Running Shoes Fit Matters Most

    • Motion Control. Shoe that is designed for runners with low arches who tend to overpronate more than those with normal arches.…

    • 646 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Enterprise Sales
    • 1911 Words
    • 8 Pages

    Enterprise Sales

    20 Years of IT/SAP experience • NPD / PMO Organization Architect • PLM Portfolio & Process Design • To Level 5 (ABC Costing) • 16 years SAP Project Management • Security, SAS 70 Type II • Data Center Hosting • Service Delivery…

    • 1911 Words
    • 8 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Oracle Business Intelligence Foundation 10.3.1 Sales Specialist Assessment
    • 2077 Words
    • 13 Pages

    Oracle Business Intelligence Foundation 10.3.1 Sales Specialist Assessment

    Correct. An integrated BI tools business case can be built around cost savings, scalability and development efficiency.…

    • 2077 Words
    • 13 Pages
    Good Essays
    Read More
  • Powerful Essays

    Course Outline Ch 2
    • 5939 Words
    • 24 Pages

    Course Outline Ch 2

    CHAPTER 2: DATA WAREHOUSING Objectives: After completing this chapter, you should be able to: 1. Understand the basic definitions and concepts of data warehouses 2. Understand data warehousing architectures 3. Describe the processes used in developing and managing data warehouses 4. Explain data warehousing operations 5. Explain the role of data warehouses in decision support 6. Explain data integration and the extraction, transformation, and load (ETL) processes 7. Describe real-time (active) data warehousing 8. Understand data warehouse administration and security issues CHAPTER OVERVIEW Data warehousing is at the foundation of most BI. This is the data warehousing chapter of the book. Later chapters will use it as they discuss DW applications such as business analytics and data mining. I.…

    • 5939 Words
    • 24 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    SAP NetWeaver and mySAP CRM: Vision for Continued Business Success
    • 2268 Words
    • 10 Pages

    SAP NetWeaver and mySAP CRM: Vision for Continued Business Success

    Implementation Partners SAP® Active Global Support, a part of SAP Customer Services Network EZ Commerce Global Solutions Solution and Services SAP NetWeaver™: SAP Enterprise Portal (SAP EP) and SAP Business Intelligence (SAP BI) mySAP™ Customer Relationship Management (mySAP CRM) Existing Environment SAP R/3® (now available in mySAP ERP) mySAP Business Suite Legacy systems…

    • 2268 Words
    • 10 Pages
    Powerful Essays
    Read More
  • Good Essays

    SAP BW Infosource
    • 645 Words
    • 3 Pages

    SAP BW Infosource

    An InfoSource combines quantity of information that logically belongs together, summarized into a single unit. It prepares consolidated data for updating to the data targets. InfoSources contain either transaction data or master data (attributes, texts and hierarchies).…

    • 645 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Business Intelligence: Generic Extraction
    • 3167 Words
    • 13 Pages

    Business Intelligence: Generic Extraction

    TS -> What data to be extracted from source system to BW. TS is a…

    • 3167 Words
    • 13 Pages
    Good Essays
    Read More
  • Powerful Essays

    Oracle EBS
    • 2271 Words
    • 43 Pages

    Oracle EBS

    Oracle E-Business Suite APPS, SYSADMIN, and oracle Securing Generic Privileged Accounts May 15, 2014 Mike Miller Stephen Kost Chief Security Officer Chief Technology Officer Integrigy Corporation Integrigy Corporation Phil Reimann Director of Business Development Integrigy Corporation Agenda Best Practices Overview 1 2 EBS Privileged Accounts 3 Q&A 4 Logging Auditing & Monitoring 5 About Integrigy ERP Applications Databases Oracle E-Business Suite Oracle, SQL Server, MySQL Products…

    • 2271 Words
    • 43 Pages
    Powerful Essays
    Read More
  • Better Essays

    REPORT SAP
    • 1206 Words
    • 8 Pages

    REPORT SAP

    Senior Manager of PETRA had been mentioned that the cost of implementing the SAP in ATLAM was not the main concern. This is because we have the project sponsor which is Faris. The reason he sponsored the project is because he want to promote the SAP system to the ATLAM. It is good for ATLAM to accept the sponsor since they cannot afford the expenses of implementing SAP system. There might be no sponsor in the future if ATLAM did not implement the system now. In order to ensure the decision of implementing SAP system is feasible, we need to evaluate and analyse the SAP system first.…

    • 1206 Words
    • 8 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Obiee training doc
    • 787 Words
    • 4 Pages

    Obiee training doc

    OBIEE online training provides a solid foundation on OBIEE 11g step-by-step procedures for building and verifying the three layers of an Oracle BI repository.…

    • 787 Words
    • 4 Pages
    Satisfactory Essays
    Read More

Related Topics