Desktop Intelligence XI R2 Foundations |
|
|
|
Course Length - 1 Day Description This class is a combination of instructor-led lecture, discussions, and demonstrations with emphasis on Desktop IntelligenceTM XI R2 Reporting concepts. Topics to be covered include introduction to BusinessObjectsTM architecture, creating simple reports, using report functions, creating conditions, basic report formatting, simple drilling, and using the Slice and Dice panel. You Will Learn The student will acquire skills to: - Understand the Basic Architecture of BusinessObjectsTM
- Build Simple Queries
- Create Table, Financial, Crosstab, and Chart Blocks
- Use BusinessObjectsTM Reporting Functions
- Use Basic Report Formatting and Styles
- Slice and Dice Data
- Create Drill-down Reports
- Create Reports using Multiple Data Sources
- Export Data
- Share Reports
PrerequisitesBasic Windows Skills Who Should AttendThis class is designed for project managers and IT professionals who are interested in understanding the role of BusinessObjectsTM as an interface to the data in a data warehouse, data mart, or database.
OutlineBusinessObjectsTM Basic Architecture - Product Diagrams
- Queries, Reporting, and Analysis
- Administration
- Advanced Analysis
- Portal
Introduction to BusinessObjectsTM - Role of BusinessObjectsTM
- Data Sources and Providers
- What Is a Universe?
- BusinessObjectsTM Users
- Objects (Dimensions, Details, and Measures)
- Report Manager
- Query Panel
- Block Styles
- Editing Existing Queries
- Report Manipulation
- Building Queries
- Predefined Conditions
- Simple Conditions
Basic Report Formatting and Styles - Working with Cells and Columns
- Formatting Cells
- Free-standing Cells
- Creating Table Blocks
- Creating Financial Blocks
- Creating Crosstab Blocks
- Creating Charts
Conditions - Predefined Conditions
- Simple Conditions
- Creating
- Removing
- Condition Components (Object, Operator and Operand)
- Pattern Matching and Wildcards
- Type a New Constant Operand
- List of Values Operand
- Prompts
- Multiple Conditions (Using And, Or, and Shifting)
Slice and Dice - Overview
- Object Manipulation/
- Block Structure Transitioning/
- Ranking/
- Breaking/
- Sorting
- Filtering/
- Master/Detail (Sectioned) Reports/
- Calculations/
- Transposing to Charts
Simple Drilling - Basic Hierarchies
- Drill Down
- Drill Up
- Drill Across
- Drill Through
Multiple Data Providers - Using Multiple Universes
- Using Personal Files
- Linking Data Providers
Exporting Data - Local File Formats (Including Excel)
- DDE (Dynamic Data Exchange)
Report Sharing - Sharing with BusinessObjectsTM Users
- Sharing with Non-BusinessObjectsTM Users
|