Anyone responsible for creating and designing universes using Universe Designer, using Business Objects XI 3.0/3.1.
- Working knowledge of SQL and relational database management systems concepts and structures.
- Familiarity with the type of data and the logical structure of the databases in your organization.
- Familiarity with Business Objects Web Intelligence report building.
3 Days. Hands on.
This course is available on site only. Please call for details.
This course is designed to teach comprehensive skills to design, build and maintain Business Objects 6.5, Business Objects XI R1/R2, and Business Objects XI 3.0/3.1 universes.
You should attend this course to understand universe design concepts and terminology, as well as the role of universes in relation to Business Objects reporting tools. The course provides an overview of 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.
The business benefit of this course is that you learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users are able to create reports without having to know anything about the underlying data source or structure.
Exploring Universe Designer Interface:
Building and Populating the Universe Structure.
Defining Joins in a Universe.
Creating and Explaining Universe Objects:
Universe Loops and Traps:
Resolve Loops Using Aliases.
Resolve Loops Using Contexts.
Resolving SQL Traps.
Using @functions with Objects
Creating and Working with Hierarchies
Working with Lists of Values
Creating and Working with Delivered Tables and Indices:
Applying Index Awareness.
Deployment and Maintenance.