SAP BusinessObjects: Universe Design XI 3.0/3.1

Overview

• Design, build and maintain BusinessObjects universes.
• Understand universe design concepts and terminology, as well as the role of universes in relation to BusinessObjects reporting tools.
• Understand the process for planning, designing and creating a universe and then walks you through the process of designing a universe that responds to identified requirements.
• Utilise best-practice methodology for creating universes that respond to reporting requirements.
• Create reports without having to know anything about the underlying data source or structure.

SAP BusinessObjects Universe Design provides all the skills needed to design, build and maintain an SAP BusinessObjects XI 3.0/3.1 Universe. Delegates will learn universe design concepts and terminology as well as the role of universes in relation to SAP BusinessObjects reporting tools
New features covered in the XI 3.0/3.1 course that are not applicable to BusinessObjects 6.5 or XI R1/R2 users include:
• Creating a cascading list of values associated with a hierarchy of objects
• Creating delegated measures
• Creating nested derived tables
• Using Translation Manager
• Testing universe results in Web Intelligence Rich Client.

Prerequisites

• Attendance of SAP BusinessObjects Web Intelligence Report Design XIR3 or experience in the same.
• Experience in SQL and relational database management systems
• Familiarity with the type of data and the logical structure of the databases in your organization

Course Outline.

Understanding BusinessObjects Universes
• Define BusinessObjects universe concepts
• Use the universe development cycle

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 Designer

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

QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.