XI3.1 Universe Design

Delegates will learn universe design concepts and terminology as well as the role of universes in relation to SAP BusinessObjects reporting tools.

Who should attend?

The target audience for this course is anyone responsible for creating and designing universes in SAP BusinessObjects

Delegates will be able to

• Design, build and maintain SAP BusinessObjects universes.
• Understand universe design concepts and terminology, as well as the role of universes in relation to SAP BusinessObjects reporting tools.
• Understand the process for planning, designing and creating a universe, then walk through the process of designing a universe that responds to identified requirements.
• Utilise best practice methodology for creating universes that respond to 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 Web Intelligence XI R2 Report Design and/or Web Intelligence XI 3.0/3.1 Report Design and/or Web Intelligence FastTrack Rich Client or Web Intelligence FastTrack Web Client

• The meta data and the logical structure of the databases in your organisation.
• Using and working with SQL and relational database management systems.

Additional education

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

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

 Topics covered

Creating the Course Universe

• Describe the course database and universe
• Create the course universes

Building the Universe Structure

• Populate the universe structure
• Define joins in a universe

Creating Dimension Objects

• Describe classes and objects
• Create classes and objects

Creating Measure Objects

• Define measure object concepts 
• Create measure objects
• Create delegated measure objects

Resolving Loops in a Universe

• Understand loops
• Resolve loops using aliases 
• Resolve loops using contexts

Resolving SQL Traps

• Understand SQL traps and universes
• Resolve fan traps 
• Resolve chasm traps

Applying Restrictions on Objects

• Restrict the data returned by objects
• Using @functions with Objects 
• Use @functions

Using Hierarchies

• Understand hierarchies and universes
• Work with hierarchies 
• Using Lists of Values 
• Create a list of values 
• Work with LOVs in Universe Designer 
• Create a cascading LOV

Creating Derived Tables and Indexes

• Use derived tables
• Apply index awareness

Linking Universes

• Understand linked universes
• Create links between universes

Applying Universe Access Restrictions

• Set access restrictions on a universe

Managing Universes

• Document universes
• Deploy universes 
• Maintain universes 
• Deploy universes in multiple languages