SAP BusinessObjects: Advanced Universe Design XI 3.0/3.1

Overview

• Comprehensively design universes in BusinessObjects Universe Designer.
• Utilise 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.

This two day advanced course is aimed at delegates who are responsible for creating and designing universes using Universe Designer, using BusinessObjects XI 3.0/3.1.
Delegates will be most successful in this course if they have experience in working with Business Objects Universe Designer.
New features in this course that are not applicable to BusinessObjects XI R1/R2 users include:
• Creating universes from stored procedures and JavaBeans
• Creating, modifying, and updating universes from OLAP data sources using the enhanced OLAP functionality in Universe Designer

Prerequisites

• SAP BusinessObjects Universe Design XIR2, and/or SAP BusinessObjects Universe Design XIR3
• SAP BusinessObjects Web Intelligence XI R2: Report Design, and/or
• SAP BusinessObjects Web Intelligence XI 3.0/3.1: Report Design
• Familiarity with the metadata and logical structure of the databases in your organization
• Using and working with SQL and relational database management systems concepts and structures
• Familiarity of the BusinessObjects Central Management Console

Course Outline.

Reviewing Universe Design Concepts
• Use your universe design and 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
• Optimize 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

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