OracleAS Discoverer 10g: Create Queries and Reports

start > courses and registration > training feature sheet

code.

10gAS-DISCO-QR

length.

2 days

type.

Instructor-Led

partner.

Oracle

price.

$1,200 :: contact for GSA GOV.

This class is applicable to Oracle 9iAS Discoverer users.

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.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

	Business Analysts
	End Users

prerequisites

	Familiarity with Microsoft Windows applications
	Familiarity with Web browsers
	SQL Basic Knowledge

skills gained

	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

suggested next courses:

Oracle Discoverer Administrator 10g: Develop an EUL

related courses, exams and materials

	after related training and products

Oracle Discoverer Administrator 10g: Develop an EUL

course content details

	Introducing OracleAS Discoverer 10g

	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 Ad-hoc Queries

	Creating a Query: Workflow
	Using the Workbook Wizard
	Editing a Query

	Managing Queries

	Building and Executing Queries
	Controlling Query Execution
	Managing Worksheets
	Managing Workbooks
	Setting Query Management Options

	Customizing Display Properties

	Result Set Display Options
	Setting Default Worksheet Display Options
	Customizing Display Properties for The Current Worksheet

	Applying Conditions and Using Parameters

	Selecting and Applying Predefined Conditions
	Selecting and Applying User-Defined Conditions
	Creating a New Condition
	Nesting Conditions
	Using Parameters
	Creating Parameterized Conditions

	Creating Group Sorts and Applying Summary Functions

	Sorting Output: Overview
	Sorting and Grouping Data in Tables
	Sorting Data in Crosstabs
	Creating Totals and SubTotals
	Creating and Displaying Percentages

	Creating Calculated Items

	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 and Managing Reports in Batch Mode

	Scheduling Workbooks Using Discoverer Plus
	The Scheduling Manager Window

	Analyzing Data with Drills

	Identifying the Drill Types
	Drill Up or Down
	Drilling to an External Application

	Analyzing Data Graphically

	Displaying Data Graphically
	Creating a New Graph
	Editing Graphs
	Customizing Graphs
	Using Pie Charts

	Exporting a Worksheet to Other Applications and Printing a Worksheet

	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

	Introducing Oracle9iAS Discoverer Viewer

	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

	Introducing OracleAS Discoverer Viewer

	Connecting to Oracle9iAS Discoverer Viewer
	Discoverer Portlets
	Customizing Discoverer Portlets