Creating universes with SAP BusinessObjects : create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool / / Taha M. Mahmoud |
Autore | Mahmoud Taha M |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, [England] : , : Packt Publishing, , 2014 |
Descrizione fisica | 1 online resource (310 p.) |
Disciplina | 658.472 |
Collana | Professional expertise distilled |
Soggetto topico |
Database management
Relational databases |
Soggetto genere / forma | Electronic books. |
ISBN | 1-78217-091-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910463298703321 |
Mahmoud Taha M | ||
Birmingham, [England] : , : Packt Publishing, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Creating universes with SAP BusinessObjects : create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool / / Taha M. Mahmoud |
Autore | Mahmoud Taha M |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, [England] : , : Packt Publishing, , 2014 |
Descrizione fisica | 1 online resource (310 p.) |
Disciplina | 658.472 |
Collana | Professional expertise distilled |
Soggetto topico |
Database management
Relational databases |
ISBN | 1-78217-091-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910787810803321 |
Mahmoud Taha M | ||
Birmingham, [England] : , : Packt Publishing, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Creating universes with SAP BusinessObjects : create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool / / Taha M. Mahmoud |
Autore | Mahmoud Taha M |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, [England] : , : Packt Publishing, , 2014 |
Descrizione fisica | 1 online resource (310 p.) |
Disciplina | 658.472 |
Collana | Professional expertise distilled |
Soggetto topico |
Database management
Relational databases |
ISBN | 1-78217-091-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910823198403321 |
Mahmoud Taha M | ||
Birmingham, [England] : , : Packt Publishing, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|