Abstract:
This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop Intelligence advanced reporting concepts. Topics to be covered include advanced query features, sub-queries, combination queries, hierarchies, variables, outlining, managing filters, inserting special fields, and conditional reporting.

Audience:
This class is designed for both technical and non-technical business analysts working in a business environment who require access to information contained in a data warehouse to generate a variety of reports and graphs utilizing Desktop Intelligence Advanced Reporting tools.

Duration:
1 Day

• View SQL
• Create User Objects
• Learn New Reporting Tips & Techniques
• Use Advanced Query Techniques
• Perform Advanced Drilling
• Work With Hierarchies
• Create Complex Queries

• Conditional Reporting
• Managing Filters
• Special Fields
• Using Find
• Outlining
• Snapshots
• Drill on Multiple Hierarchies
• Drill Through/By
• Scope of Analysis
• Predefined/Custom Hierarchies
• Calculation Queries
• Subqueries
• Union/Intersect/Minus Queries
• User Objects
• Viewing SQL
• Review of Basic Reporting Topics

• BusinessObjects 3.0/3.1 Desktop Intelligence Intermediate Reporting