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
  • Powerful Essays

    Business Intelligence Software
    • 1173 Words
    • 5 Pages

    Business Intelligence Software

    As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software industry today.…

    • 1173 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Emphasize Business Intelligence software Solution as SiSense and Birst
    • 783 Words
    • 3 Pages

    Emphasize Business Intelligence software Solution as SiSense and Birst

    Today’s software solution makes it possible for companies to remain in top position by looking at the company’s oversight database and analytics based business actions. BI solutions are valuable for any company to encourage complete strategy, get better information and sharing across software platforms. This assignment based on two top Business Intelligence software solutions as SiSense, and Birst and the explanation of why I choose SiSense software BI as the best. Both SiSense and Birst have key features with Data collection, 3rd-party data integration, Data visualization, Customizable dashboards, Self-service, Mobile accessibility, Adhoc analytics and reports. The only major difference between two of these tools are SiSense has a key feature with SaaS hybrid platform and Birst has SaaS no hybrid platform. Even though, both are experiencing high performance to the customer as a BI solution, it is hard to separate from each other or other high-ranking software solutions. I recommend best SiSense BI software solution, because of its business analytics, effective data dashboard design absolute guidelines open for business users. It is the only business intelligence and dashboard software, which lets business users join, analyze, and visualize increasing data sets from multiple sources without IT experience. It is designed to bring sophisticated data scientist-class analyses to everyday users. Nevertheless, it is end-to-end business intelligence solution with powerful visuals and business support. Its’ secret style is the absurd technology that was designed to be used by business users, without dependence on coding. On the business market SiSense make available a centralized database of standard hardware, serves more queries, more users, and more data than any other BI tool.…

    • 783 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

    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

    Business Intelligence Software at Sysco
    • 965 Words
    • 4 Pages

    Business Intelligence Software at Sysco

    SYSCO is a huge company that had 420,000 customers ranging from huge chain restaurants to “mom-and-pop” diners. It is a highly decentralized business composed of over 100 operating companies. Each operating company managers had substantial autonomy. In this organization, it’s very hard to collect all the information from all the operation companies, to say nothing of analyzing and using the data of all companies. The main reason why it’s hard to use the data is the huge amount of information. The original data contain too much information and it is useless for the decision maker to make a right decision. But with BI system, this problem could be solved easily. With BI’s capability of extraction, the companies can retrieval of data from different sources. Then it’s much easy for the executives to choose the useful information to use for the decision making. Data mining is another important capability of BI. It can analyze the large pools of historical…

    • 965 Words
    • 4 Pages
    Good 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

    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
  • 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
  • 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
  • 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

Related Topics