Preview

Business objects

Powerful Essays
Open Document
Open Document
3321 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Business objects
SAP Business Objects - Sample
Universe on Microsoft SQL Server

Applies to:
SAP BusinessObjects XI4, the information design tool and Microsoft SQL Server 2005 & 2008. For more information, visit the Business Objects homepage.

Summary
This article describes the content of the sample universe for Microsoft SQL Server. It explains how to set up the universe in the information design tool and how to make it available to the SAP Business Objects client tools. Download the attached file here to retrieve the information design tool sample resources as well as the sample database. Download attached files here.
Author:

Marc Daniau

Company: SAP
Created on: 26 July 2011

Author Bio
Marc Daniau joined Business Objects in 1992 as project consultant in France. He moved to the product group in San Jose in 1998 to work on EPM products. He moved back to Paris in 2003 to work within the semantic layer team.

SAP COMMUNITY NETWORK
© 2011 SAP AG

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

SAP Business Objects - Sample Universe on Microsoft SQL Server

Table of Content
The Business Layer ............................................................................................................................................ 3
Sales View ...................................................................................................................................................... 3
Purchase view ................................................................................................................................................. 3
Customer care view ........................................................................................................................................ 4
Inventory view ................................................................................................................................................. 4
Finance view

You May Also Find These Documents Helpful

  • Satisfactory Essays

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

    Todd Lubar Research Paper

    • 297 Words
    • 2 Pages

    His major experience in several industries helped him understand how to make business work and how to outclass in almost any environment. At the meantime he entered yet another industry which is focused on helping people in need. He is currently the President of TDL Ventures.…

    • 297 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    During Week 1, the primary learning activity is to set up the programming and database environments that you will use in completing the course labs. We will investigate TCO 5 by learning how to use Visual Studio to connect to a MySQL database. This…

    • 1818 Words
    • 8 Pages
    Better Essays
  • Good Essays

    studied sculpture and product design. He had joined GM at the age of 21, and held the same…

    • 354 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    He created his own business 6 years ago in 2010. In an interview with him he stated…

    • 240 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Bis245 Ilab

    • 2683 Words
    • 11 Pages

    A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.…

    • 2683 Words
    • 11 Pages
    Satisfactory Essays
  • Satisfactory Essays

    DBM 380 Syllabus

    • 623 Words
    • 4 Pages

    This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.…

    • 623 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Sap America Case Study

    • 1429 Words
    • 6 Pages

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

    4. Technical requirements: - Latest SQL server i.e., SQL server 2014 sp1 (basic SQL commands), the latest version of Microsoft Visio 2013, Microsoft excel 2013 and Oracle Database 10g were the technical requirements of this…

    • 550 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    On June 4,1980 he joined Proctor & Gamble as young professional in U.S marketing division. Initially he was brand assistant for SOLO laundry liquid. Ex-Captain of US army started his marketing experience by selling SOLO and particularly had a hard time selling it. During his interview to Modern Weekly…

    • 2362 Words
    • 10 Pages
    Better Essays
  • Best Essays

    Pernici, B., & Rolland, C. (2012). Automatic Tools for Designing Office Information Systems: The TODOS Approach. Springer Science & Business Media, 2012.…

    • 1988 Words
    • 6 Pages
    Best Essays
  • Good Essays

    Admin

    • 558 Words
    • 3 Pages

    Managing and Creating a Database Using MS-Access, SQL Server 2000 or 2003, Oracle, and MySQL.…

    • 558 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Data Modeling Tools

    • 498 Words
    • 2 Pages

    Visio 2003 provides specific solutions for Database diagrams that support the IDEF1X modeling technique, relational notations, object-relationship models, entity-level and schema-level diagrams, and product data models using EXPRESS-G notation. Diagrams can be created by dragging shapes to a drawing page or by reverse engineering an existing database structure from a variety of compatible databases, including Microsoft SQL Server™, Microsoft Access, Oracle, and IBM's DB2.…

    • 498 Words
    • 2 Pages
    Good Essays
  • Good Essays

    1970’s as a consortium of European aerospace firms, and was integrated into a single company in 2001.…

    • 3873 Words
    • 16 Pages
    Good Essays
  • Powerful Essays

    Assumption ........................................................................................ 3 1. 2. 3. 4. 5. 6. Conceptual Data Model ...................................................................... 4 Relational Schema .............................................................................. 5 Normalization ..................................................................................... 6 SQL Code and Testing........................................................................ 12 Screen Design and Testing .................................................................. 18 Report Design and Testing .................................................................. 27…

    • 1809 Words
    • 8 Pages
    Powerful Essays