Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

1 Introduction to Administering Discoverer

This chapter introduces you to administering Oracle Business Intelligence Discoverer, and includes the following topics:

1.1 What is Oracle Business Intelligence Discoverer?

Oracle Business Intelligence Discoverer is an intuitive ad-hoc query, reporting, analysis, and Web publishing toolset that gives business users immediate access to information in databases.

Oracle Business Intelligence Discoverer enables business users at all levels of the organization to make faster and more informed business decisions. Using any standard Web browser, they have secure and immediate access to data from both relational and multidimensional data sources. Oracle Business Intelligence Discoverer provides a business view to hide the complexity of the underlying data structures, enabling you to focus on solving business problems.

Oracle Business Intelligence Discoverer consists of several integrated components that work with the Oracle database to give a complete and integrated Business Intelligence solution.

Figure 1-1 Oracle Business Intelligence Discoverer components

Description of Figure 1-1 follows
Description of "Figure 1-1 Oracle Business Intelligence Discoverer components"

Which Oracle Business Intelligence Discoverer component you use will depend on what you want to do. For example:

The Oracle Business Intelligence Discoverer components use definitions of Discoverer objects stored in the Discoverer End User Layer or the Discoverer Catalog.

For more information, see "What are the components of Oracle Business Intelligence Discoverer?".

1.2 What are the components of Oracle Business Intelligence Discoverer?

Oracle Business Intelligence Discoverer comprises the following components:

1.3 What is the role of the Discoverer manager

The role of the Discoverer manager is to make sure that end users are able to use Discoverer Plus, Discoverer Plus OLAP, Discoverer Viewer and Discoverer Desktop. The Discoverer manager might be responsible for any of the following tasks:

1.4 What tools does the Discoverer manager use?

The Discoverer manager uses the following tools:

1.5 What data sources can you use with Discoverer?

You can use the following data source with Discoverer:

Relational data sources differ from multi-dimensional data sources in the following ways:

1.6 Basic concepts for Discoverer managers

Before you start administering Discoverer, you will find it helpful to familiarize yourself with some basic concepts:

1.6.1 What is business intelligence?

Business intelligence is the ability to analyze data to answer business questions and predict future trends.

Oracle Business Intelligence Discoverer is a great business intelligence tool because it enables users to analyze data in an ad hoc way. Instead of relying on IT specialists to pre-define queries and reports, Discoverer users can choose the data to analyze and can continue manipulating results until they have the necessary information to take business decisions. Oracle Business Intelligence Discoverer also enables users to share the results of their data analysis with their colleagues in different formats (including charts and Excel spreadsheets).

1.6.2 How does Discoverer work?

Users' requests for information from the database are in the form of worksheets.

When a user creates or opens a worksheet, Discoverer:

  • converts the worksheet into the corresponding SQL statements (for example, by converting folder names and item names to table names and column names respectively)

  • sends the SQL statements to the database

  • displays the result set that is returned from the database

In the case of Discoverer Plus, Discoverer Desktop and Discoverer Viewer, the SQL statements are routed to the database through Discoverer processes running on an application server machine.

1.7 Where should I look for more information?

Where you find more information about administering Discoverer will depend on which data source you are using, as follows: