Creating Universes with SAP BusinessObjects -- Table of Contents -- Creating Universes with SAP BusinessObjects -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why subscribe? -- Free access for Packt account holders -- Instant updates on new Packt books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 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 -- 2. Aligning BI Solutions with Business Demands -- Northwind -- 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 -- 3. Creating Our First Universe -- Information Design Tool -- The main features of the IDT -- The 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 project -- Creating 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 -- 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 tables -- List 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 -- 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 -- Main properties -- SQL Definition -- The Select property -- The Where property -- The Extra Tables property -- Keys -- Controlling advanced properties.

Access Level -- Objects can be used in -- Database Format -- List of Values -- Display -- Source Information -- Custom Properties -- Attributes -- Measures -- Difference between the database and projection functions -- Filters -- How to create a filter -- Filter properties -- Summary -- 6. Testing Your Universe -- The Universe development life cycle -- Initiation -- Planning and design -- Implementation and development -- Quality assurance and testing -- SIT -- UAT -- Closing -- Using the Check Integrity wizard -- Queries in the Business layer -- Summary -- 7. The Data Foundation Layer - Advanced Topics -- Design concepts -- Information systems -- Online transactional processing -- Online analytical processing -- The DWH schema types -- The snowflake schema -- The star schema -- The relational model -- Advanced design techniques of Data Foundation -- Alias tables -- Context -- The shortcut join -- Advanced Data Foundation properties -- Description -- SQL Options -- Summary -- Parameters -- SQL design traps -- The fan trap -- Solving a fan trap -- The chasm trap -- Solving the chasm trap using context -- Solving the chasm trap using an alias table -- Loop -- Fixing the loop using the shortcut join -- Fixing the loop using context -- Fixing the loop using an alias table -- Summary -- 8. The Business Layer - Advanced Topics -- List of values -- List of values based on a dimension object -- List of values based on the query panel -- List of values based on a custom hierarchy -- Static list of values -- List of values based on custom SQL -- Navigation paths -- The default navigation path -- The custom navigation path -- Index awareness -- Primary keys -- Foreign keys -- Aggregate awareness -- Inserting aggregated tables -- Defining the aggregated objects -- Detecting the aggregation navigation -- Common business objects' specific functions.

@Aggregate_Aware() -- @DerivedTable() -- @Prompt() -- @Select() -- @Variable() -- @Where() -- Multilingual Universes -- Advanced Business layer properties -- Description -- Summary -- Change Data Foundation -- Parameters -- Summary -- 9. Data Security and Profiles -- Understanding the security model -- Working with the Security Editor -- Universes / Profiles -- Users / Groups -- Understanding Data Security Profiles -- Connections -- Controls -- SQL -- Rows -- Tables -- Understanding Business Security Profiles -- Create Query -- Display Data restriction -- Filters -- The security matrix -- Summary -- 10. A Multiuser Development Environment -- Working with projects -- Local projects -- Creating a local project -- Opening a local project -- Deleting a local project -- Shared projects -- Creating a shared project -- Renaming and deleting a shared project -- Synchronizing projects -- Promotion and the life cycle management console -- Promoting a Universe from one environment to another -- Promoting NorthWind using the LCMBIAR file -- Promoting NorthWind using the Live to Live method -- The Upgrade Management Tool -- Converting UNV to the new Universe UNX extension -- Summary -- Index.