BusinessObjects XI R1/R2: Advanced Universe Design
|
|
| Audience | The target audience for this course is anyone responsible for creating and designing universes using a BusinessObjects Enterprise XI R2 SP2 environment. You will be most successful if you have experience working with BusinessObjects Designer. |
| Prerequisites | To be successful in this advanced course, you must have working knowledge of:
SQL and relational database management systems concepts and structures Familiarity with the metadata and logical structure of the databases in their organization BusinessObjects Universe Designer BusinessObjects Web Intelligence |
| Synopsis | The business benefit of this course is that you will 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 | Universe Development Process
Understanding the metadata Universe Development Cycle Best practices for universe design
Universe Parameters
Data access files and connection parameters BusinessObjects dynamic SQL parameters Connection and user credential parameters
Advanced Objects Scenarios
Combining database functions in objects Constructing relative date-time objects Working with Transact_SQL functions
Complex Predefined Conditions, LOVs and Joins
Complex predefined conditions Advanced LOVs Advanced Join syntaxes
SQL Traps Revisited
Chasm Traps Fan Traps
Extended Index Awareness and Derived Tables Applying Index Awareness Derived Tables
External Strategies
Cresting and using external strategies
|
|