Using the Reports

This chapter provides an overview of the reports and describes how to run them.

This chapter covers the following topics:

• Overview of the Reports
• Common Report Concepts
• Generating and Viewing Reports

Overview of the Reports

Use the reports to analyze data from business processes in your application or to evaluate data quality. The availability of specific reports in the Documents tab depends on your application and responsibility. See:

• Overview of Data Management Reports.

• Overview of Oracle Financial Services Audit Reports.

• Overview of Oracle Transfer Pricing Reports.

Discoverer Plus: The Reporting Tool

Use Oracle Discoverer Plus 10gR2 to generate reports, and to customize these reports in line with your reporting needs. Discoverer Plus is:

• An Internet application tightly integrated with Oracle E-Business Suite.

• A business intelligence solution that allows business users to retrieve and analyze data from Oracle databases by creating worksheets and charts, and to publish those results.

See:

• Overview of the Oracle Financial Services Reporting Structure.

• Oracle Business Intelligence Discoverer Plus User's Guide.

• Oracle Business Intelligence Discoverer Administration Guide.

• Oracle Business Intelligence Discoverer Viewer User's Guide.

Each report contains worksheets that have either the crosstab or table layout. See: About Discoverer worksheet types, Oracle Business Intelligence Discoverer Plus User’s Guide.

Related Topics

Common Report Concepts

Generating and Viewing Reports

Common Report Concepts

The following concepts are common to the reports. Not all concepts, for example conditions and totals, apply to every report.

• Business Area Folders: Folders set up in the Discoverer end user layer (EUL) or business area that contain database objects, such as data and fact tables, on which reports are based.

• Joins: Temporary relationships between two tables in a database query that let you retrieve the exact data that you want.

  For example, the join Line Items Dimension Hierarchy -> EPF Balances is a one-to-many (1:n) join between Line Items Dimension Hierarchy.Level20 id and EPF Balances.Line Item.

• Conditions: Restrictions added to business area folders that limit the data available, within a given table, to a set of users.

• Page Items: Parameters that reports are based on.

• Rows

• Report Headings and Calculations (Columns)

• Totals: Sum of all values in a particular column.

Related Topics

Overview of the Reports

Generating and Viewing Reports

You can run the reports from your application, or use the Oracle Discoverer Desktop or Discoverer Administration applications themselves. See: Oracle Business Intelligence Discoverer Desktop User's Guide and Oracle Business Intelligence Discoverer Administration Guide.

Procedure to generate reports from your application

1. Navigate to the Documents tab.

2. Click the report you want to run.

Tip: Use the Back button of the browser to navigate back to your application. Open a new browser window to view both your application and the Discoverer Plus application simultaneously.

Related Topics

Overview of the Reports

Oracle Business Intelligence Discoverer Plus User's Guide

Oracle Business Intelligence Discoverer Viewer User's Guide