Overview:
This course utilizes an instructor-led lectures and discussion format coupled with progressive hands-on exercises designed to illustrate the following topics in BusinessObjects XI environment; role of Universes, universe design principles methodology, locating required tables, using Joins, depict usage of classes and objects, understand List of Values concept, creating advanced objects like conditional and interactive objects, defining Universe hierarchy via classes and objects and Universe distribution and incorporating Supervisor settings in our design
Audience:
IT professionals that will be designing, creating, documenting, maintaining and deploying BusinessObjects XI Universes for their clients.
Prerequisites:
Student should be familiar with basic Windows concepts and be able to function efficiently in Windows 2000/XP environment. Each student should have completed Introduction to Data Warehousing or understand the basic role of a Data Warehouse structures.
Objectives
- Understand the role of BusinessObjects Universes.
- Illustrate the critical path for designing
and developing BusinessObject Universes.
- Define the capabilities of Universe parameters.
- Incorporating the usage of table Joins.
- Understand the role of Classes and Objects.
- Illustrate the use of @ functions in Universe
creation.
- Use of the List of Values to increase product
usability.
- Define the role of hierarchies in Universe
creation.
- Illustrate techniques for query optimization
within Universe design.
- Understand the process of Universe deployment.
- Utilize Supervisor to define groups and users
- Defining and controlling Universe parameters:
SQL, data and row restrictions, table mappings
and command restrictions
Class Format
Lecture and Lab
Course duration:
3 days
Course outline:
BusinessObjects
Designer
- Client role
- Data Warehouse
- Data utilization by users
- Warehouse data: real-time, reconciled,
derived, changed and metadata
- Using a data warehouse
- BusinessObjects environment
- Role of the BusinessObject universe
- Integrating data warehouse to BusinessObject
universe
- Universe design principles
- Defining metadata layer
- Universe components
- Schema support
- User/Client segmentation
- BI stakeholders
Alias
& Contexts
- Fact vs Lookup tables
- Loops
- Loop detection
- Cardinality detection
- Defining Alias
- Using alias with SQL
- Resolving loops with an alias
- Create Alias with Designer
- Alias detection
- Defining Contexts
- Context impact on SQL
- Ambiguous Queries
- Inferred Queries
- Create Contexts in Designer
- Context vs Alias
Tables
and Columns
- Initiating Designer
- Online vs Offline mode
- Designer interface panel
- Classes, Objects & Filters
- Designer toolbar
- Universe creation process
- Database connections
- Built-in strategies
- SQL query options
- Table browser
- Manipulate Table entries
- Join properties and options
Classes &
Objects
- Defining Class, Object and Condition
operations
- Create new Class
- Class properties
- Subclasses
- Object creation
- Object properties
- Use of WHERE clause
- @Prompt
- @Script
- @Select
- @Variable
- @Where
- Measures
- List of Values
- Condition creation
External
Strategies
- Defining Strategies
- Built-in and External strategies
- Building SQL strategy files
- Flat file strategy file
- Stategy output formats
- Join strategies
- Applying external strategies
Aggregrate Awareness
- Definition
- Methodology
- Aggregrate aware objects
- @Aggregrate_Aware
- Object analysis
- Compatible objects
Table
Joins
- Defining Joins
- Supported Join types
- Cardinality
- Building Joins w/ Designer
- Using Detect
- Candidate joins
- Manual join operations
- Editing joins
- Formula bar
- Equi-join creation
- Theta join
- Outer join
- Detect join cardinalities
- Integrity checks
Multidimensional
Analysis
- Definition
- Time hierarchy
- Time limitations
- Drill-through components
- DTS Manager
- Universe Drill-through service (UDS)
- UDS Maps
- Candidate joins
- Manual join operations
Supervisor operations
- Security
- User Types and Profiles
- Adding users
- User properties
- Adding groups
- Universe properties
- Table mappings
Universe Maintenance
- Saving updates
- Enterprise vs workgroup
- Print options
- Repository distribution
- File distribution
- Exporting
- Importing
|
