OracleAS Discoverer 10g: Create Queries and Reports

Revision: TE1919_20060509

(6.61 KB) View, Download, or Print Catalog as a PDF.

Course Length:

2 Days

Course Description:

This course introduces students to the querying and analytical capabilities of OracleAS Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using OracleAS Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically and how to format query results to create customized reports. Students will learn how to create simple and advanced calculations to perform data analysis and create reports that answer a variety of business questions, such as year-to-year comparisons and ranking. In addition, students will learn how to schedule reports in batch mode, share workbooks with other users, and export reports to other applications, including MS Excel, HTML, and Oracle Reports. Finally, students will learn how to view and customize Discoverer portlets using OracleAS Portal. This course also provides students with the prerequisite skills necessary for the "Oracle Discoverer 10g: Develop an EUL" course.

Who Should Attend:

This course is for business analysts and end users.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Display data graphically.
• Filter data by using conditions and create parameterized reports.
• Schedule reports in batch mode.
• Share workbooks with other users.
• Export workbooks to other applications.
• Open a workbook and analyze data using OracleAS Discoverer Viewer.
• Use and customize Discoverer Portlets in OracleAS Portal.
• Analyze data by using totals, percentages, and advanced calculations.
• Generate reports and ad hoc queries.
• Select default worksheet format options.
• Format data, headings and background in a worksheet.

Prerequisites:

Students should have familiarity with Microsoft Windows applications and Web browsers and have basic SQL knowledge.

Course Outline:

• Introducing OracleAS Discoverer 10g
  1. Business Intelligence Tools
  2. Discoverer Components
  3. Connecting to Discoverer Plus
  4. Data Warehouse Versus Transactional Systems
  5. Using Discoverer with a Data Warehouse
  6. Online Help and Key Terminology
  7. The Discoverer Administrator
  8. The Training Database
• Creating Ad-hoc Queries
  1. Creating a Query: Workflow
  2. Using the Workbook Wizard
  3. Editing a Query
• Managing Queries
  1. Building and Executing Queries
  2. Controlling Query Execution
  3. Managing Worksheets
  4. Managing Workbooks
  5. Setting Query Management Options
• Customizing Display Properties
  1. Result Set Display Options
  2. Setting Default Worksheet Display Options
  3. Customizing Display Properties for The Current Worksheet
• Applying Conditions and Using Parameters
  1. Selecting and Applying Predefined Conditions
  2. Selecting and Applying User-Defined Conditions
  3. Creating a New Condition
  4. Nesting Conditions
  5. Using Parameters
  6. Creating Parameterized Conditions
• Creating Group Sorts and Applying Summary Functions
  1. Sorting Output: Overview
  2. Sorting and Grouping Data in Tables
  3. Sorting Data in Crosstabs
  4. Creating Totals and SubTotals
  5. Creating and Displaying Percentages
• Creating Calculated Items
  1. Identifying Types of Calculations
  2. Creating a Simple Calculation
  3. Building a Complex Calculation
  4. Using the Analytic Calculations Templates
  5. Creating Analysis Calculations
  6. Using Calculations in a Condition
  7. Passing a Parameter to a Calculation
• Scheduling and Managing Reports in Batch Mode
  1. Scheduling Workbooks Using Discoverer Plus
  2. The Scheduling Manager Window
• Analyzing Data with Drills
  1. Identifying the Drill Types
  2. Drill Up or Down
  3. Drilling to an External Application
• Analyzing Data Graphically
  1. Displaying Data Graphically
  2. Creating a New Graph
  3. Editing Graphs
  4. Customizing Graphs
  5. Using Pie Charts
• Exporting a Worksheet to Other Applications and Printing a Worksheet
  1. Exporting a Worksheet into Other Applications
  2. Exporting to Excel or HTML
  3. Exporting an Worksheet to an Excel Pivot Table
  4. Exporting to Oracle Reports in XML Format
  5. Printing a Worksheet Using the Print Wizard
• Introducing Oracle9iAS Discoverer Viewer
  1. Connecting to Oracle9iAS Discoverer Viewer
  2. Using the Main Features of Discoverer Viewer
  3. Setting Query Execution Options
  4. Setting Presentation Options
  5. Creating a Bookmark to a Worksheet Using Discoverer Viewer
• Introducing OracleAS Discoverer Viewer
  1. Connecting to Oracle9iAS Discoverer Viewer
  2. Discoverer Portlets
  3. Customizing Discoverer Portlets