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...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, [England] :
Packt Publishing
2014.
|
| Edición: | 1st edition |
| Colección: | Professional expertise distilled
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628698806719 |
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 byDetect; 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
- Dimensions
