Oracle Discoverer Reporting

Duration 2 days
Delivered by iWareLogic’s team of expert Oracle BI instructor and consultants, this course covers the following topics:
  • Business Intelligence Tools
  • Discoverer Components
  • Connecting to Discoverer Plus
  • Data Warehouse Versus Transactional Systems
  • Using Discoverer with a Data Warehouse
  • Online Help and Key Terminology
  • The Discoverer Administrator
  • The Training Database
  • Creating a Query: Workflow
  • Using the Workbook Wizard
  • Editing a Query
  • Building and Executing Queries
  • Controlling Query Execution
  • Managing Worksheets
  • Managing Workbooks
  • Setting Query Management Options
  • Result Set Display Options
  • Setting Default Worksheet Display Options
  • Customizing Display Properties for The Current Worksheet
  • Selecting and Applying Predefined Conditions
  • Selecting and Applying User-Defined Conditions
  • Creating a New Condition
  • Nesting Conditions
  • Using Parameters
  • Creating Parameterized Conditions
  • Sorting Output: Overview
  • Sorting and Grouping Data in Tables
  • Sorting Data in Crosstabs
  • Creating Totals and SubTotals
  • Creating and Displaying Percentages
  • Identifying Types of Calculations
  • Creating a Simple Calculation
  • Building a Complex Calculation
  • Using the Analytic Calculations Templates
  • Creating Analysis Calculations
  • Using Calculations in a Condition
  • Passing a Parameter to a Calculation
  • Scheduling Workbooks Using Discoverer Plus
  • The Scheduling Manager Window
  • Identifying the Drill Types
  • Drill Up or Down
  • Displaying Data Graphically
  • Creating a New Graph
  • Editing Graphs
  • Customizing Graphs
  • Using Pie Charts
  • Exporting a Worksheet into Other Applications
  • Exporting to Excel or HTML
  • Exporting an Worksheet to an Excel Pivot Table
  • Exporting to Oracle Reports in XML Format
  • Printing a Worksheet Using the Print Wizard
  • Connecting to Oracle9iAS Discoverer Viewer
  • Using the Main Features of Discoverer Viewer
  • Setting Query Execution Options
  • Setting Presentation Options
  • Creating a Bookmark to a Worksheet Using Discoverer Viewer
  • Connecting to Oracle9iAS Discoverer Viewer
  • Discoverer Portlets
  • Customizing Discoverer Portlets

The course includes slides and delegate notes, and can be delivered on-site or through partner organizations. Quotations can be provided for custom versions of this course, or to include additional areas not covered in the regular agenda.

To book this course for you or your organization, or for more information, contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 
Moving Stones Technologies