Oracle AS Discoverer 10g Create Queries and Reports

Course: ODISQR

Duration: 2 Days

Level: I

Course Summary

This class will teach students the purpose and capabilities of the Discoverer 10g AS tool. Thereafter each user can learn to apply this knowledge to the company's internal data model.

« Hide The Details

Topics Covered In This Course

DATA ANALYSIS REVIEW

WHAT IS DATA ANALYSIS
INTRODUCTION TO ORACLE10G DISCOVERER
DISCOVERER COMPONENTS
IMPORTANT TERMINOLOGY
THE TRAINING ENVIRONMENT

CREATING QUERIES

STARTING DISCOVERER AS
ONLINE HELP
THE WORKBOOK WIZARD
THE RESULTS WINDOW

QUERY MANAGEMENT

MANAGING WORKBOOKS
SAVING WORKBOOKS
OPENING WORKBOOKS
DELETING WORKBOOKS
SHARING WORKBOOKS
MANAGING WORKSHEETS
MOVING/COPYING WORKSHEETS
EDITING WORKSHEETS
RENAMING AND DELETING WORKSHEETS

MODIFYING THE DISPLAY

ADDING A REPORT TITLE
ADDING A REPORT FOOTER
PRINT PREVIEW/PAGE SETUP OPTIONS
PAGE SETUP OPTIONS
FORMATTING HEADINGS
MODIFYING HEADING PROPERTIES
FORMATTING DATA
CHANGING DEFAULT COLUMN SIZE
MODIFYING DATA DISPLAY PROPERTIES
SETTING HEADING AND DATA FORMAT DEFAULTS

WORKING WITH CONDITIONS AND PARAMETERS

WORKING WITH CONDITIONS
VIEWING, APPLYING, DISABLING CONDITIONS
CREATING NEW CONDITIONS
USING THE NEW CONDITION DIALOG
MULTIPLE AND NESTED FORMULA CONDITIONS
CREATE CONDITIONS USING THE ANALYSIS BAR
EDITING CONDITIONS
WORKING WITH PARAMETERS
VIEWING, APPLYING, AND DISABLING PARAMETERS
CREATING NEW PARAMETERS
EXECUTING THE QUERY WITH THE PARAMETER WIZARD
EDITING PARAMETERS

WORKING WITH CONDITIONAL FORMATS AND CALCULATIONS

WORKING WITH CONDITIONAL FORMATS
HOW CONDITIONAL FORMATS ARE USED
VIEWING, APPLYING, DISABLING EXCEPTIONS
CREATING AND EDITING CONDITIONAL FORMATS
WORKING WITH CALCULATIONS
VIEWING, DISPLAYING, HIDING CALCULATIONS
CREATING CALCULATIONS USING THE EDIT CALCULATION DIALOG
CREATING CALCULATIONS USING THE TOOL BAR
EDITING CALCULATIONS

WORKING WITH SORTS, TOTALS, AND PERCENTAGES

WORKING WITH SORTS
CREATING COLUMN SORTS
CREATING GROUP SORTS
THE SORT TABLE DIALOG
WORKING WITH TOTALS
VIEWING, DISPLAYING, HIDING TOTALS
CREATING/EDITING TOTALS USING THE TOTAL DIALOG
WORKING WITH PERCENTAGES
VIEWING, DISPLAYING, HIDING PERCENTAGES
CREATING/EDITING PERCENTAGES
USING THE PERCENTAGE DIALOG
USING THE TOOL BAR TO CREATE PERCENTAGES
DRILLING THE DATA
USING DRILLS IN DISCOVERER
DRILLING FROM THE WORKBOOK WINDOW
USING THE DRILL DIALOG
SPECIFYING DRILL OPTIONS
DRILLING TO EXTERNAL APPLICATIONS

GRAPHING DATA

CREATING A GRAPH
SELECTING A GRAPH TYPE
THE GRAPH WINDOW

WORKBOOK MAINTENANCE

SCHEDULING WORKBOOKS
SCHEDULE WORKBOOK DIALOG
SCHEDULING MANAGER
OPENING SCHEDULED WORKBOOKS
EXPORTING DISCOVERER OUTPUT
USING THE EXPORT DIALOG

WORKING WITH SQL AND SETTING OPTIONS

VIEWING, EXPORTING, AND IMPORTING SQL
THE SQL INSPECTOR/PLAN DISPLAY
SETTING DISCOVERER OPTIONS
GENERAL OPTIONS
QUERY GOVERNOR OPTIONS
SHEET OPTIONS
FORMAT OPTIONS
ADVANCED OPTIONS
EUL OPTIONS

USING SQL FUNCTIONS IN DISCOVERER

USING FUNCTIONS IN DISCOVERER
FUNCTION CATEGORIES
TYPES OF FUNCTIONS
STRING FUNCTIONS
CHARACTER STRING FORMATTING FUNCTIONS
CHARACTER STRING MANIPULATION FUNCTIONS
NUMERIC FUNCTIONS
NUMERIC COMPARISON AND PRESENTATION FUNCTIONS
DATE FUNCTIONS
DATE RECALCULATION FUNCTIONS
NESTING FUNCTIONS
USING ANALYTIC FUNCTIONS

INTRODUCTION TO DISCOVERER VIEWER

WHAT IS DISCOVERER VIEWER
STARTING DISCOVERER VIEWER
USING DISCOVERER VIEWER
DIFFERENCES BETWEEN DISCOVERER PLUS AND DISCOVERER VIEWER

INTRODUCTION TO DISCOVERER DESKTOP INTERFACES (OPTIONAL)

DISCOVERER DESKTOP
USING DISCOVERER DESKTOP
COMPARE/CONTRAST PLUS AND DESKTOP
PREPARING FOR PRACTICE EXERCISES
WORKSHOP SYSTEM REQUIREMENTS
EXTRACTING THE STUDENT FILES
PREPARING TO RUN THE SQL SCRIPTS
CREATING STUDENT ACCOUNTS
CREATING THE CAMP_SRC SCHEMA
BUILDING THE END USER LAYER AND BUSINESS AREA
SETTING SECURITY AND PRIVILEGES
REGISTERING THE SALES_TAX() FUNCTION
COPYING THE SAMPLE WORD DOCUMENT
TESTING THE SETUP

Who Should Take This Course

The course is designed to teach end users and administrators in two different environments: client/server desktop or web-based.