Creating universes with SAP BusinessObjects : create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool / / Taha M. Mahmoud

• Record Nr.: UNINA9910823198403321
• Autore: Mahmoud Taha M
• Pubbl/distr/stampa: Birmingham, [England] : , : Packt Publishing, , 2014; ©2014
• ISBN: 1-78217-091-X
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (310 p.)
• Collana: Professional expertise distilled
• Disciplina: 658.472
• Soggetti: Database management; Relational databases
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.; "Professional Expertise Distilled." -- Cover.
• Nota di contenuto: 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
• Sommario/riassunto: 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 Universe developer who is looking for a fast way to map your old experience in Universe designer to the newer Information Design Tool, then this book is for you as well.