Course Search:

Oracle - AS Discoverer 10g: Create Queries and Reports (Windows)

Description:
This class will teach students the purpose and capabilities of the Oracle BI Discoverer 10g AS tool. Thereafter, each user can learn to apply this knowledge to the company`s internal data model.
  • Cost: Price on application
  • Duration: 2 days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Oracle Application Server 10g: Administration I is recommended, but not mandatory.
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


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2010
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.