Creating universes with SAP BusinessObjects : create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool /
This book is aimed at both new developers as well as experienced developers. If you are a new SAP BusinessObjects Universe developer who is looking for a step-by-step guide supported with real-life examples and illustrated diagrams, then this book is for you. If you are a seasoned BusinessObjects Un...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham :
Packt Publishing,
2014.
|
Colección: | Professional expertise distilled.
|
Temas: | |
Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to BI and the Semantic Layer; What is Business Intelligence?; Business Intelligence concepts; The knowledge pyramid; Hindsight, insight, and foresight; BI and DWH; BI reporting tools architecture; The one-tier architecture model; The two-tier architecture model; The three-tier architecture model; What is a semantic layer?; Introduction to Universes and the Information Design Tool; History of SAP Business Objects; Summary.
- Chapter 2: Aligning BI Solutions with Business DemandsNorthwind; The BI Maturity Model; Configuring and setting up Northwind''s database; Getting the Northwind sample database; Creating the ODBC Connection; The Northwind data model; Dimensional modeling terminologies; Order information; Inventory information; Summary; Chapter 3: Creating Our First Universe; Information Design Tool; The main features of the IDT; Information Design Tool interface; Local Projects; Repository Resources; Security Editor; Project Synchronization; Check Integrity Problems; Creating your first Universe step by step.
- Creating a new projectCreating a new data connection; Creating a new Data Foundation; Creating a new Business layer; Saving and publishing the Northwind Universe; Finding help while creating a Universe; The Universe wizard; Cheat Sheets; Summary; Chapter 4: Creating the Data Foundation Layer; Working with data connections; The relational connection; The OLAP connection; Building the Data Foundation layer; Types of Data Foundation; Single Source; Multisource-Enabled; Physical tables and views; Alias tables; Derived tables; Using the @Prompt functionality in a derived table.
- Nested derived tablesList of derived tables; Joining tables; Cardinality; Key types; A primary key; A foreign key; Join types; Equal joins; Theta joins; Outer joins; Self joins; Data Foundation menus and functions; Detecting joins; Detecting cardinalities; Detecting the row count; Refreshing the structure; Managing families; Save the view as an image; The search panel; Auto-arranging tables; Controlling the Data Foundation display; Insert View; Data Foundation visualization; Data Foundation object manipulation; Insertion; Table manipulation; Add to View; Edit; Merge; Delimit; Set Case To.
- Replace by Detect; Change Qualifier/Owner; The table''s values and display; Count Rows; Show Table Values; Select Related Tables; Highlight Related Tables; Display; Centre on Selection; Show Local Dependencies; Highlight Aliases; The table''s basic functions; Summary; Chapter 5: Creating the Business Layer; Gathering requirements; The Business layer''s main window; The left panel; The Properties panel; The Data Foundation panel; Business Layer; Managing Business layer views; Showing/hiding the search panel; Expand and collapse all; Display Options; Inserting objects; Business objects; Folders.