Friday, December 19, 2014

Overview of Discoverer.


Oracle Discoverer is a business intelligence tool to support organizational decisions and data will show in the form of excel format.

Components of discoverer:-

1.Discoverer Adminstration Edition

2. Discoverer Desktop Edition

Architecture Of Discoverer Administartion Edition:-

i.End User Layer

ii.Business Area

iii.Business Folders

What is the End User Layer(EUL?


The End User Layer (EUL) is the meta data (i.e. data about the actual data in a database) that is simple and easy for users to understand. You use Discoverer Administration Edition to create, customize, and maintain this view for your users so they can easily access data in Discoverer Plus. You must have access to at least one EUL in order to use Discoverer Administration Edition or Discoverer Plus. 

What is  Business Area?

A business area is a collection of related information in the database.

A business area is a set of related information with a common business purpose

For example, information about Sales may be stored in one business area, while
information about Cops is stored in another business area.

In simple words it can be termed as collections of objects in a particular module

 What is Business Folders:-

-Simple Folders – Folders that are based on a database table (e.g.: ITEM)

-Custom Folders – Folders that contain a custom SQL query.

-Complex Folders – Folders that are based on multiple simple folders.

No comments: