AUDIENCE:   This course is for Oracle Discoverer end users and technical support professionals. PREREQUISITES:   Delegates should be familiar with Web browsers and a good knowledge of Windows applications is required. DURATION:   2 days. Hands on. OBJECTIVES:   On completion of the course delegates will be able to: - Create, modify and run ad hoc queries. - Create filters and use functions. - Schedule reports. - Share workbooks with other users and export reports to other applications. COURSE CONTENT:   Discoverer Concepts Identifying the concepts and components of Oracle Discoverer 4i(web edition)/4.1(Desktop) Explaining the role of the Oracle Discoverer Administrator Connecting to Discoverer Describing Discoverer support for Oracle Applications Creating Ad Hoc Queries Using the Workbook Wizard Creating a simple query and viewing the Output Customizing the output Managing Queries Building and executing queries Controlling query execution Customizing Worksheets Managing Workbook Setting Advanced Options Customizing Display Properties Customizing heading, page and data properties Formatting numbers and setting background Creating exceptions (*) Applying Conditions and using Parameters Selecting and applying predefined conditions Creating conditions Creating complex conditions Creating parameters Creating parameterised conditions Creating Subqueries (*) Creating a simple subquery condition Creating a correlated subquery condition Creating Group Sorts and Applying Totals Creating a group sort Applying subtotals and totals in results Creating percentages Creating Calculated Items Identifying types of calculations Creating simple and complex calculated items Modifying a calculation Passing parameters to calculations Applying simple and complex SQL functions including Analytical functions Scheduling Scheduling reports Using the scheduling manager Analysing Data With Drills Identifying different drill types Using the Drill Dialog Box Drilling to a related item (*) Drilling directly with hyperdrills Drilling to external applications Analysing Data Graphically Creating different graphs types Customising graphs, Titles and Legends Drilling within graphs Importing and Exporting Reports Exporting reports to Excel, HTML, Notepad or Oracle Reports Sending workbooks via e-mail Exporting and Importing SQL Using the command-line interface (*) – Where available