Oracle BI Discoverer comprises the following components:
- Oracle Business Intelligence Discoverer Plus This component runs over the internet or intranet and enables you to:
- create new worksheets and graphs to get the data you want
- analyze the data
- share worksheets and graphs with other people
- Oracle Business Intelligence Discoverer Viewer
This Oracle BI Discoverer component runs over the internet or intranet inside a web browser. Use Discoverer Viewer to analyze the data in worksheets created in Discoverer Plus, and Discoverer Desktop. You can personalize worksheets (for example, by repositioning items) and save your changes. For more information about Discoverer Viewer, see the Oracle Fusion Middleware User’s Guide for Oracle Business Intelligence Discoverer Viewer
- Oracle Business Intelligence Discoverer Portlet Provider and Discoverer portlets:
These Oracle BI Discoverer components run over the internet or intranet inside a web browser. Use Discoverer Portlet Provider to include Discoverer worksheets as areas (or portlets) within existing Oracle Portal pages. Discoverer Portlet Provider enables you to publish the following types of Discoverer portlet:
- a List of Worksheets portlet
- a Worksheet portlet
- a Gauges portlet
You can personalize worksheets (for example, by adding stoplight formatting) and save your changes.
- Oracle BI Discoverer Desktop
This Oracle BI Discoverer component is a Windows-only application that enables you to build new worksheets to analyze data from relational data sources. The worksheets you create in Discoverer Desktop can be used in Discoverer Plus, Discoverer Viewer, and Discoverer portals.
- Oracle BI Discoverer Administrator
This Oracle BI Discoverer component is a Windows-only application used by the Discoverer manager to create and maintain a business oriented view of relational data. Discoverer Administrator provides wizards and dialogs to:
- control access to data
- manage summary data
- administer batch scheduling
- Oracle BI Discoverer End User Layer (EUL)
The Discoverer End User Layer component is a repository for storing and retrieving definitions of objects used when querying relational data sources.
- Oracle BI Discoverer Catalog
The Discoverer Catalog component is a repository for storing and retrieving definitions of user objects when querying multidimensional data sources.
Simple and easy steps to Oracle Business Intelligence Discoverer
Following are the steps to develop report in Oracle discoverer. Query is developed in Discoverer Administrator and Layout is developed in Discoverer Desktop or Discoverer Plus. Example is of Purchase Order report.
- Login into Discoverer Administrator.
Create a New Business Area
Select the table or View on which you would like to place you Report
To provide access for this report to any User or Responsibility, you need to set its Security. Security can been set for the entire Business Area
2) You can also use a pre defined Business Area. Select Business Area. For e.g. The Common Reports
3) Create New Custom Folder and enter SQL Query and give name to that folder as per the standards. If you want to develop using View then select New Folder from Database.
4) Validate the SQL. Click OK.
Here are the screen shots for creating the workbooks in the Discoverer Desktop:-
1) Login into Discoverer Desktop.
2) Create New Workbook and select display results(Table, Crosstab, Page-Detail Table and Page-Detail Crosstab) as per requirement.
3) Select the folder or required fields of folder for which you are creating Workbook.
4) Make the layout as per requirement by rearranging the fields and adding fields to Page Items. Hide duplicate rows by clicking the check box (if necessary).
5) Finally the report is developed and it looks like this
We need to set the security for the Desktop also.
File–>Manage Workspace –> Sharing
Permission needs to be set for each Work Book. Here responsibilities are also treated as a User.
Step-by-step to create a report in Discoverer Plus
1) log into discoverer Plus using the URL
2) Click on ‘Create a new workbook’ and select only ‘Title’; leave others unchecked. Click Next.
3) select your Common Report Folder. And select the columns that you would like to display in the Report
4) The report would look like the following
5) Save your report by going to File -> Save. Save frequently to avoid losing changes.
You can add parameters to the report using the add Parameter option on the tool bar. Ypu can dynamically select the columns that you would like to display on the report by selecting the columns from the Selected Items in below the page.
Log in using the URL.
It is similar to the Plus. Only difference is that the user will not be able to chose his own parameters. The parameters will need to be defined by the developer at the Administrator. Depending n the client requirement the access of the Viewer or the Plus would be given