Desktop Intelligence XI R2 Advanced Reporting

Course Length - 1 Day

Description

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop Intelligence^TM 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.

 You Will Learn

The student will acquire skills to:

Prerequisites

Desktop Intelligence^TM XI R2 Intermediate Reporting (1 Day).

Who Should Attend

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^TM Advanced Reporting tools.

Outline

Desktop Intelligence^TM Overview

• Corporate Information Factory
• Data Warehousing
• Desktop Intelligence^TM Data Sources/Providers
• Objects Overview
• Blocks Overview
• Report Creation Overview
• Query Building Overview
• Block Creation Overview
• Multiple Data Providers Overview
• Variables and Formulas Overview

• Viewing/Using SQL
• User Objects
• Duplicating Data Providers

• Create A Subquery (All) Operand
• Create A Subquery (Any) Operand
• Create A Subquery Operand
• Calculation Operand
• Using Query on Query Capability

• Union Queries
• Intersect Queries
• Minus Queries

• Predefined Hierarchies
• Creating Custom Hierarchies
• Scope of Analysis
• Drill Through
• Drill By
• Drilling on Multiple Hierarchies
• Drilling on Charts
• Snapshots

• Formula Examples (ForEach, ForAll, In, If-Then-Else)
• Outlining
• Managing Filters
• Inserting Special Fields
• Conditional Reporting