This three-day course is designed for this course is designed to give learners the comprehensive skills needed to design, build and maintain BusinessObjects XI R3 Universes.
SAP BusinessObjects Universe Design
- A solid understanding of relational databases and client-server concepts is required.
- Delegates must be SQL-literate.
- Participants should be familiar with report creation using either BusinessObjects, Desktop Intelligence or Web Intelligence.
Participants will gain the knowledge to create and deploy BusinessObjects Universes with in the XIr3 Environment
Understanding BusinessObjects Universes
Understanding how Universes allow users to query databases using their everyday business Terms.
Creating the Course Universe
- The course database and Universe
- Creating the Universe
Building the Universe Structure
- Populating the Universe structure
- Defining joins in a Universe
Creating Dimension Objects
- Understanding classes and objects
- Creating classes and objects
Creating Measure Objects
- Understanding measure objects
- Creating measure objects
Using Lists of Values
- Working with LOVs in Designer
- Creating a cascading LOV
Resolving loops in a universe
- Resolving loops using aliases
- Resolving loops using shortcut joins
- Resolving loops using contexts
Resolving SQL Traps
- Resolving chasm traps
- Resolving fan traps
Applying Restrictions on Objects
Restricting the data returned by objects
Using Functions with Objects
Using @ Functions
Working with hierarchies
Derived Tables and Indexes
- Using derived tables
- Applying index awareness
Creating links between Universes
Setting access restrictions on a Universe
- Documenting Universes
- Deploying & maintaining Universes
This is a QA approved partner course
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at firstname.lastname@example.org to discuss how we can help.
Fully accredited to ensure we provide the highest possible standards in learning