On-line training course catalogue

Oracle iDS: Discoverer for Administrators

Type of course: Classroom

Course details

Fee	£1320
Days	3
Course code	ORDISCA

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

This course introduces delegates to administering Discoverer 4.1, which is a part of Oracle 9i Developer suite. As a Discoverer administrator, delegates learn to create and customise the End User Layer (EUL), to create business areas and folders, and to define analytical facilities for end users. Delegates also learn to grant and control user access to the End User Layer (EUL), and use Oracle 8i materialised views and automated summary management in Discoverer 4.1.

Prerequisites

Delegates should have completed course D41U, Discoverer for End Users and SPLi, Introduction to Oracle: SQL and PL/SQL.

Delegates will learn how to

• Customise the End User Layer
• Implement and administer Oracle Discoverer 4.1
• Design, create, maintain and control user access to the End User Layer (EUL)
• Optimise query performance
• Discuss the architecture of Oracle Discoverer for the Web

Outline

INTRODUCTION TO ORACLE DISCOVERER 4.1 ADMINISTRATION:

Positioning discoverer in Oracle?s internet platform; differentiating data warehouse and OLTP systems; using Oracle discoverer with data warehouses; integrating Oracle discoverer with business intelligence tools – describing discoverer components; discussing discoverer for Windows and the Web; identifying key terminology; outlining the role of the data administrator; outlining the training business areas and data models; creating the end user layer and business areas; creating the initial EUL; designing a business area; identifying and selecting objects to import; creating and loading meta data into a business area; customising a business area; exporting and importing; granting user access to a business area; controlling user privileges and properties; defining data access requirements for end users and administrators

CREATING LOVS, ALTERNATIVE SORTS, AND CONDITIONS:

Discussing item classes; creating lists of values; creating an alternative sort; creating optional or mandatory simple and advanced conditions; creating calculated items and registering PL/SQL functions; customising item and folder properties; creating simple calculated items; registering and importing PL/SQL functions

CREATING COMPLEX AND CUSTOM FOLDERS:

Creating joins; discussing join options; creating complex and custom folders; creating analytical and aggregate items; creating analytical items; creating aggregate items

CREATING DRILLS:

Identifying end user drill facilities; using the hierarchy wizard to create an item hierarchy; using the item class wizard to create a drill-to-detail; defining and setting up a hyperdrill plug-in; explaining the default date hierarchy; creating a custom date hierarchy and a non-standard calendar using binary large objects

CREATING AND MANAGING SUMMARY FOLDERS:

Discussing different types of summary management; discussing Oracle discoverer summaries; discussing Oracle 8i materialised views; comparing discoverer summaries with materialised views; creating summary folders on your own; discussing summary combination strategies; automated summary management; using the automated summary management wizard; using the graphical interface to change space for summary tables; changing the default automated summary management policies

MANAGING BATCH SCHEDULING:

Describing batch reporting; specifying a batch repository owner; describing changes that affect batch reports; setting up scheduled workbook privileges; managing scheduled workbooks in the admin edition; maintaining the end user layer; describing the effect of database changes; refreshing the business area; deleting folders or business areas; migrating from development to a production environment; supporting multiple schema

EUL ADMINISTERING MULTIPLE END USER LAYERS AND AUTOMATING TASKS:

Discussing multiple EULs; creating an EUL for a new user; assigning a default EUL; automating tasks through the command line interface; configuring discoverer for the Web; discussing the benefits of discoverer for the Web; using discoverer 4i plus; discussing Oracle9i application Server architecture; outlining discoverer 4i plus architecture; discussing administrative tasks; opening a workbook automatically from a URL; discussing discoverer 4i viewer architecture; customising the look and feel of the discoverer 4i viewer