|Oracle Financial Services Reporting Administration Guide|
Part Number E13529-03
This chapter provides an overview of the reports and describes how to run them.
This chapter covers the following topics:
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:
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.
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.
Common Report Concepts
Generating and Viewing Reports
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.
Report Headings and Calculations (Columns)
Totals: Sum of all values in a particular column.
Overview of the 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
Navigate to the Documents tab.
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.
Overview of the Reports
Oracle Business Intelligence Discoverer Plus User's Guide
Oracle Business Intelligence Discoverer Viewer User's Guide
Copyright © 2006, 2009, Oracle and/or its affiliates. All rights reserved.