This chapter contains the following topics:
JD Edwards EnterpriseOne has three integrations with Oracle Business Intelligence (BI) Publisher. Each integration addresses a specific reporting requirement: producing customer facing documents, enabling end users to create their own operational reports, and providing power users and IT staff with the ability to create complex ad hoc reports. This section provides a summary of each integration and common use cases for each.
Embedded BI Publisher for JD Edwards EnterpriseOne: Transforms the output from a UBE into customer facing documents (Pixel Perfect). Common use cases for Embedded BI Publisher with JD Edwards EnterpriseOne are invoices, statements, pick slips, and checks.
See the JD Edwards EnterpriseOne Tools BI Publisher for JD Edwards EnterpriseOne Guide for more information.
One View Reporting: Enables end users to create and run their personalized reports directly from JD Edwards EnterpriseOne interactive applications. These reports are typically specific to the user or role and are those that users will run on a daily, weekly, or other periodic basis as part of their normal activities. Users require a high degree of personalization regarding data selection, sequencing, data columns included, and data visualization (charts, tables, graphs) with this type of report. These end user reports improve user productivity by providing users with better visibility into operational data as part of their standard day-to-day business process. One View Reporting enables users to select data fields and perform specific data selection from within JD Edwards EnterpriseOne applications and leverage the layout capabilities within BI Publisher to define the report output formatting. Common use cases might be sales reports, customer reports, supplier reports, and employee reports. This guide describes the installation, configuration, and administrative tasks for the One View Reporting integration and use cases.
Ad Hoc Reporting: Allows power users and IT staff to build powerful queries to interrogate data on an ad hoc basis. This type of report is typically created to meet a specific business requirement outside of the normal business process, and it is only run once or twice. These reports typically require users to create a SQL statement to retrieve the data (query builder). The query is usually created by the IT department or a power user who understands the JD Edwards EnterpriseOne data schema. After building the query, IT or a power user will create a report layout with tables and charts to display the data (template builder). This integration leverages the JD Edwards EnterpriseOne JDBC Driver and Oracle BI Publisher Enterprise Edition. This integration has commonly been called ”interactive reporting.” By definition, there are no common use cases.
Oracle's JD Edwards EnterpriseOne One View Reporting provides an intuitive, easy-to-use method for you to access data and produce reports with Oracle BI Publisher.
You can easily run existing reports or create new reports that contain tables, graphs, and charts and view them in a variety of formats, such as PDF documents, HTML, and Excel spreadsheets. Additionally, many reports enable you to interactively filter the report data for further analysis.
One View Reporting allows the use of standard and customized find browse forms to locate report data. Release 9.1 also introduces One View applications, which use joined business views to access records from multiple tables. The One View find browse forms combine business transactional and master data in combinations not previously available, and you can view these data combinations in the BI Publisher layout you choose. You can also use Data Browser to locate report data and produce One View reports.
The benefits of One View Reporting include:
Reducing the cost of developing and maintaining reports by eliminating IT support for most reporting needs.
Improving total cost of ownership by eliminating the need for third-party reporting products.
Improving end user satisfaction by providing easy, real-time access to information.
Enabling business decision making by providing low cost access to information.
Reducing the cost of system upgrades by reducing or eliminating custom applications that were required for viewing data or producing reports.