Oracle 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
Overview of Business Areas:-
-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
Overview of 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.
Here are the steps for creating the ‘Business area’
Open Discoverer Administrative Edition