| Course Length - 2 Days |
| |
| Course Description This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjectsTM XI R2 basic Designer concepts. Topics to be covered include universe creation, creating database connections, joins, classes and objects, hierarchies, loop resolution, contexts, table aliases, aggregate awareness, viewing table keys, creating predefined conditions, restrictions, universe maintenance, and universe distribution/documentation. |
| |
You Will Learn How To: The student will acquire skills to: - Create and Maintain Universes
- Join Database Tables and Set or Detect Join Cardinality
- Create Classes and Objects within Hierarchies
- Define Dimensions, Details, and Measures
- Using Contexts and Aliases
- Create Predefined Conditions
- Use Desktop IntelligenceTM XI R2 Reporting Tool to Test Universes and SQL Generation
|
| |
Course Prerequisites - Basic Windows Skills
- Some Database Background
- Some SQL Skills
- Desktop IntelligenceTM XI R2 Basic Reporting Course(Recommended)
|
| |
Who Should Attend? This class is designed for technical analysts who are required to create the BusinessObjectsTM XI R2 semantic layer as an interface to the data in a data warehouse, data mart, or database. |
| |
Next Recommended Course BusinessObjectsTM Administrators |
| |
| Course Outline: |
| Desktop IntelligenceTM Overview |
- Basic Architecture
- Administration
- Semantic Layer
- Definitions Review
- Universe Development Process
|
| Getting Started |
- Using Designer
- Defining Database Connection
- Setting Parameters
- Inserting Database Tables
|
| Joins |
- Defining Joins
- Methods of Creating Joins
- Creating Equi-joins
- Creating Outer Joins
- Creating Theta Joins
- Detecting Joins
|
| Classes and Objects |
- Defining Classes/Subclasses
- Defining Object Types
- Class and Object Organization
- Creating Classes
- Creating Dimensions/Details
- Object Properties
- List of Values
- Deleting Objects
- Testing Cycle
|
| Measures |
- Creating Measures Class
- Creating Simple Measures
- Creating Measures Using Arithmetic Formula
- Formatting Measures
|
| Resolving Loops |
- Using Aliases
- Using Contexts
- Checking Universe Integrity
|
| Restrictions |
- Forced Restrictions
- Object-level Restrictions
- Self-restricting Joins
- Conditional Select Statements
- Additional Inferred Joins
- Optional Restrictions
- Predefined Conditions
|
| @Functions |
- @Prompt
- @Select
- @Where
- @Variable
- @Script
|
| Hierarchies |
- Hierarchy Types
- Default Hierarchies
- Automatic Time Hierarchies
- Table Based Time Hierarchies
- Custom Hierarchies
|
| Aggregate Awareness |
- Summary Tables
- Creating Aggregate Derived Tables
- Applying Aggregate Awareness
- @AggregateAware
- Detecting & Setting Incompatible Objects
|
| Resolving Traps |
- Fan Traps
- Chasm Traps
- Procedures for Resolving Traps
|
| Reviewing Security Restrictions |
- Group & User Security
- Applying Security Restrictions
- Net Security Restrictions
|
| Documenting & Maintaining Universes |
- Documenting Universes
- Creating Hardcopies (Printing)
- Saving As PDF
- Distributing Universe
- Universe Security
- Enterprise Distribution
- Exporting Universes
- Locking Universes
- Incremental Exports
- Version Control
- Maintaining Universes
- Target Database Changes
- Impact Resolution
- Adding New Tables
- Object Revisions
- Using Group/Object/SQL Find Functionality
- Efficient Maintenance
|
