Discoverer Training

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Discoverer Training as PDF for free.

More details

  • Words: 560
  • Pages: 20
Oracle Discoverer 4i

Discoverer is an all-in-one information tool from Oracle. Discoverer gives you sophisticated ad hoc query, analysis, reporting and web publishing capabilities.

Administration Edition Is an application that database administrators use to prepare the data so users' exploration can be easy and productive. User Edition Enables business professionals to explore and analyze the data that's important to them -- while avoiding complex database structures and procedures.

Administration Edition

The Administration Edition is the tool you'll use to maximize these benefits for your users Because most databases are designed for efficient data storage, not for ease of use. Discoverer User Edition makes data in databases easy to use by presenting it with familiar business-like names, organized to serve users' needs.

To help users get the most from Discoverer User Edition, we need to perform a series of tasks. •7 Step Process

7 Step Process • • • • • • •

Perform Business Analysis of User requirements Mapping User needs to Database Structures Create End User Layer (EUL) Create Business Areas Refine Business Areas to fit User needs Use Admin Edition to maintain Business Areas Privileges to Users/Roles

End User Layer The End User Layer lies between the User Edition and the database. It shields users from the complexity of database tables, views, columns, joins, and SQL.

Business Area

A business area is a logical grouping of information from database tables or views. Within a business area, you create: Folders -- based on tables and views. Items -- based on columns.

Business areas are stored in the End User Layer.

The structure and names that you choose for the business areas, folders, and items can make the data easier for users to query and analyze.

Admin Edition Components

End User Layer Business Area Folder Items Joins

Using Admin Edition •

Providing Data Access

• •

Query and Report Formatting Drilling Through Data

Features and Benefits

Ease of use • • • • • • • •

Bulk load Automatic Join Creation List of Values Automatic drill creation Custom Folders Mandatory Stored Conditions Centralized Repository Command-line Interface

Features and Benefits

(contd...)

Enhancing User Productivity • • •

Calculated items Complex folders Item Hierarchy creation

Performance • • • •

Query Prediction Batch Controls Defining summaries from query statistics Automatic summary table maintenance

Features and Benefits

(contd...)

Openness • • • •

Integrated security Designer/2000 repository integration EUL Gateway ODBC support

User Edition With Discoverer we can: Rapidly query a relational database, data warehouse or data mart. Intuitively drill down and analyze data by simply clicking and dragging. Produce high-impact reports, presentations, and Web pages from your results. Access non-Oracle databases using ODBC. Send reports to other users via MAPI-compliant e-mail. Schedule reports to be run at a later date and time using Discoverer's batch facility.

Steps for Creating Workbook Create new workbook / Open an existing workbook Choose the type of layout • Table • Crosstab • Page-Detail table • Page-Detail crosstab Choose the Business Area Choose the required columns from folders Define conditions Define sorting options Define Calculations (Formula’s)

Features



Data filtering conditions



Sorting conditions



Total’s (group totals/ summary totals)



Percentages



Calculations



Parameters



Query Governing

Benefits



Importing SQL Query



Exporting SQL Query



Export Report data



Schedule workbook



Share Workbook



Send workbook as a mail

THANK YOU

Related Documents

Discoverer Training
November 2019 11
Discoverer
June 2020 14
Discoverer
June 2020 17
Discoverer Ppt
November 2019 13
Discoverer Steps
November 2019 8