This chapter contains the following topics:
Oracle's JD Edwards EnterpriseOne enables you to produce One View reports from search criteria in One View Reporting applications, standard or custom find browse forms, or Data Browser.
After you determine the data for a report, you select a report from the One View menu. Oracle Business Intelligence (BI) Publisher processes the report and displays it in a separate browser window.
One View reports have the following features:
Reports are available on any find browse form with a Find button.
Reports can be rendered in a variety of formats, such as Microsoft Word, Adobe Reader, and Oracle's Interactive Viewer.
The data for reports is run-time data from JD Edwards EnterpriseOne applications.
Report layouts are defined in BI Publisher Layout Editor based on information from a JD Edwards EnterpriseOne application.
One View reports are classified as either shared or personal. Shared reports are available system wide unless they are restricted by security settings. Reports that you create are classified as personal reports and appear under My Reports on the One View menu. Personal reports are available only to you. However, you have the option to promote a personal report to shared status, although the promotion request must be approved by a system administrator. If the request is approved, the report no longer appears as a personal report, but as a shared report on the One View menu.
One View Reporting combines JD Edwards EnterpriseOne and BI Publisher components to produce One View reports. These components are:
Report definition
Data model
BI Publisher report
Report layouts
The report definition for One View reports contains information about which columns are selected in the data model, the naming convention, the rowset setting, the name of the report, and so on.
A data model is an object that contains a set of instructions for BI Publisher to retrieve and structure data for a report. The data model includes sample grid data, form level information, and a reference to the data source.
The BI Publisher report component consists of the reference to the data model, report layouts, report properties, and translations.
The BI Publisher report layouts define how data is presented in a report. A layout consists of a template file and a set of properties for rendering the file. BI Publisher supports templates created from a variety of sources.
You also can design custom One View reports by creating a data model, selecting a template, and designing the report layout. If necessary, reports can include a set of translations so that they can be produced in more than one language.
When you run a One View report, data from your search criteria is combined with a report layout to produce the report output. Multiple output types are available:
Adobe Reader (PDF)
Microsoft Word (RTF)
Microsoft Excel 2007
Comma Separated Value (CSV)
Microsoft PowerPoint
Microsoft PowerPoint 2007
XML
Interactive Viewer
Interactive Viewer enables pop-up chart details, scrollable tables, table filtering, table sorting, and propagated filtering across different report components. For example, if a report displays an Open Invoice table, you can filter the results to show only those invoices with balances over a certain amount, or you can show the amounts of all open invoices in ascending or descending order.