Are you the master of your UNX universes? Written for design novices and experts alike, this comprehensive resource spans universe creation to universe publication. You'll learn to build single- and multisource data foundations and business layers and to convert UNV to UNX using the new Information Design Tool (as well as explore its important features and functionalities). Up to date for SAP BusinessObjects Business Intelligence 4.1, this book offers the step-by-step instructions and guiding screenshots you need to design universes for the world.
Topic Highlights - Semantic layer - Information Design Tool - Universe installation - Multisource data foundations - BI projects - Authentication modes - Business layer - Query Panels - Publishing and retrieving universes - Shared resources - Universe security - Universes and SAP HANA
Highlights include:
Semantic layer
Information Design Tool
Multidimensional universes
Connections, data foundations, and business layers
Federating data with multisource universes
Query panels
Publishing and retrieving universes
Shared resources
Universe security
Multilingual universes
Connecting with SAP ERP, SAP NetWeaver BW, and SAP HANA
Universe Design with SAP BusinessObjects BI: The Comprehensive Guide
Table of contents
Preface ... 23
Acknowledgments ... 27
1. Introduction to the Semantic Layer ... 29
1.1 ... What Is a Semantic Layer? ... 29
1.2 ... A Well-Designed Semantic Layer ... 33
1.3 ... Semantic Layer Components ... 35
1.4 ... Deploying the Semantic Layer in SAP BusinessObjects BI 4.0 ... 42
1.5 ... SAP BusinessObjects BI Applications that Consume the Semantic Layer ... 44
1.6 ... Summary ... 53
2. Introduction to Information Design Tool ... 55
2.1 ... Installing Information Design Tool ... 56
2.2 ... Getting Started ... 58
2.3 ... Information Design Tool Interface ... 62
2.4 ... Help ... 67
2.5 ... Preferences ... 71
2.6 ... Data Preview ... 77
2.7 ... Summary ... 83
3. Local and Shared Projects ... 85
3.1 ... Authoring Resources in Local Project ... 86
3.2 ... Managing Local Projects ... 91
3.3 ... CMS Repository ... 96
3.4 ... Managing Sessions ... 102
3.5 ... Shared Projects ... 106
3.6 ... Managing Shared Resources ... 109
3.7 ... Summary ... 115
4.
Connecting to Data Sources ... 117
4.1 ... Data Sources Typology ... 117
4.2 ... Connection Persistence ... 123
4.3 ... Authentication Modes ... 127
4.4 ... Client and Server Deployment ... 133
4.5 ... Connection Parameters ... 137
4.6 ... Managing Connections ... 141
4.7 ... Data Preview ... 150
4.8 ... Summary ... 155
5. The Data Foundation ... 157
5.1 ... Creating a Data Foundation ... 159
5.2 ... Identifying Tables, Columns, and Keys ... 162
5.3 ... Identifying Joins, Keys, and Cardinalities ... 169