Student Profile: This two-day instructor led advanced course is designed to give learners the comprehensive skills needed to design universes in BusinessObjects Designer.
Duration: 2 Days
Prerequisites: Learners who attend this course must have working knowledge of:
• The metadata and logical structure of the databases in your organization
• BusinessObjects Web Intelligence report building
• Using the BusinessObjects Universe Designer
• The BusinessObjects Central Management Console
• Using and working with SQL and relational database management systems concepts and structures
Objectives: Learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.
Topics Covered:
Reviewing Universe Design Concepts
- Use your universe design and BusinessObjects Universe Designer knowledge to solve business problems
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
- Work with analytic functions
Creating Complex Predefined Conditions, LOVs and Joins
- Create complex predefined conditions
- Work with advanced LOVs
- Work with advanced join systems
Securing Universes
- Define connection and user credential parameters
- work with Central Management Server (CMS) universe security
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
Certification Applicability: This offering is not applicable to any certification.
Cost: $1,350 | 
