2.Components and Architecture of Discoverer with Explanation.

#Components:

• Discoverer Administration Edition
• Discoverer Desktop Edition
• Discoverer Plus
• Discoverer Viewer

#Architecture:

1.End User Layer(EUL):The End User Layer of Discoverer provides a way to mask the underlying complexity of the database to provide end users with an interface they can easily understand.

2.Business Area:A business area is a collection of related information in the database.example,
Ex:information about Sales may be stored in one business area, while information about material is stored in another business area.

3.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.

Security: We will give specific business area access to users under 'Tools->Security.

:: When we open administration in discoverer we can see 4 tabs.

Data-hierarchies-item class-summaries(explanations of all these)

Data:In data tab we can see all the objects and navigation, such as Business Area,Folders and thier properties such as joins,items selected..etc

Hierarchies: We can set up items in a hierarchy to enable end users to drill up and down the hierarchy to view related information.Using Hierarchy Wizard we can create hierarchies.

Discoverer will have two types of hierarchies

1.Date Hierarchy

2.Item Hierarchy

Item Classes:We can display the list of values of the parameters. We can create item_clause in admin edition.Select the folder->expand it->right click->new item clause

Summary Folders:Discoverer summary tables are database tables created by Discoverer Administrator that contain summarized data. Discoverer summary tables contain pre-aggregated and pre-joined data, and can improve query performance in Discoverer Plus and Discoverer Viewer.

We can use the Automated Summary Management (ASM) Wizard to create summary folders in discoverer or else  we can create manually by selecting the option 'Click the I want to specify the summaries myself radio button'.