Steps to develop report in Oracle Business Intelligence Discoverer

Oracle Applications

Simple and easy steps to Oracle Business Intelligence Discoverer

A beginners guide for Oracle Business Intelligence Discoverer

----------------------------------------------------------------------------------------------------------------------------------

Steps to develop report in 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.

Note:- This is for the beginners and knowledge of basic terms of Discoverer is required.

Discoverer Administrator

1. Login into Discoverer Administrator.
2. Select Responsibility. For e.g. Responsibility4
3. Select Business Area.  For e.g. The Common Reports
4. 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.
5. Validate the SQL. Click OK.

Discoverer Desktop

1. Login into Discoverer Desktop.
2. Select Responsibility. For e.g. Responsibility4
3. Create New Workbook and select display results(Table, Crosstab, Page-Detail Table and Page-Detail Crosstab) as per requirement.
4. Select the folder or required fields of folder for which you are creating Workbook.
5. 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).
6. Add conditions if required.
7. Sort the fields as per requirement.
8. Perform calculations on fields as per requirement and click on Finish.
9. Finally the report is developed and it looks like this.