Discoverer vs Oracle Reports

Oracle Reports generates static reports. Parameters can be defined by the developer at the time of development and cannot be added at run time unlike the Discoverer Report. Discoverer generates a much more interactive report.  In Discoverer, the end user can define parameters at run time and also add mathematical calculations to the report.

It is easier to develop reports with graphs in Discoverer than in Oracle Reports.

So if the requirement is to provide an interactive report, we would go for Discoverer Report and if  the requirement is to provide a static report we would be going for Oracle Report.

Basics of Oracle BI Discoverer Reports

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.

Discoverer Administrator

  1. Login into Discoverer Administrator.

1

Create a New Business Area

1

 

1

 

Select the table or View on which you would like to place you Report

1

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

Tools–>Security

1

 

 

2) You can also use a pre defined Business Area. Select Business Area.  For e.g. The Common Reports

 

2

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.

3

4) Validate the SQL. Click OK.

4

 

Here are the screen shots for creating the workbooks in the Discoverer Desktop:-

1) Login into Discoverer Desktop.

6

2) Create New Workbook and select display results(Table, Crosstab, Page-Detail Table and Page-Detail Crosstab) as per requirement.

8

3) Select the folder or required fields of folder for which you are creating Workbook.

9

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

10

5) Finally the report is developed and it looks like this

 

11

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.

Discoverer Plus

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.

12

3) select your Common Report Folder. And select the columns that you would like to display in the Report

13

4) The report would look like the following

14

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.

15

 

 
Discoverer Viewer

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