XI3.1 Advanced Universe Design

The course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects Universe Designer.

Who should attend?

The target audience for this course is anyone responsible for creating and designing universes using Universe Designer.

Delegates will be able to

• Comprehensively design universes in SAP BusinessObjects Universe Designer.
• Utilise best practice methodology for creating universes that respond to your reporting requirements.
• Allow report designers and business users to create reports without having to know anything about the underlying data source or structure.

Prerequisites

Delegates must have attended the following courses,

• SAP BusinessObjects - Universe Design XI R2 and/or Universe Design XI R3
• SAP BusinessObjects - Web Intelligence Report Design XI R2 and/or Web Intelligence Report Design XI3.0/3.1 and/or Web Intelligence FastTrack Web Client

• The metadata and logical structure of the databases in your organisation
• Using and working with SQL and relational database management systems concepts and structures
• The SAP BusinessObjects Central Management Console

Additional education

If you want to increase your skill level and knowledge these courses are recommended,

• SAP BusinessObjects - Data Services Fundamentals XI 3.0/3.1
• SAP BusinessObjects - Data Quality Core Concepts XI 3.0/3.1
• Date Warehousing - Data Warehouse Design

Topics covered

Reviewing Universe Design Concepts

• Use your universe design and SAP BusinessObjects Universe Designer knowledge to solve business problems
• Describe the course universe, database data, and structure

Working with Aggregate Awareness

• Define aggregate awareness
• Apply aggregate awareness to objects

Designing Advanced Objects

• Combine database functions in objects
• Construct relative date-time objects

Creating Complex Predefined Conditions, LOVs, and Joins

• Create complex predefined conditions
• Work with advanced LOVs 
• Work with advanced join syntaxes

Securing Universes

• Define connection and user credential parameters
• Work with Central Management Server (CMS) universe security
• Work with table mapping

Implementing Universe Life Cycle Management

• Move content from development to production

Maintaining and Optimizing Universes

• Optimise universes
• Apply foreign key index awareness 
• Apply best practices for universe design

Creating Universes from Other Data Sources

• Create a universe from an XML metadata file
• Create stored procedure and JavaBeans universes 
• Work with OLAP universes