JD Edwards EnterpriseOne has provided a reporting solution based on Oracle's BI Publisher since JD Edwards EnterpriseOne 8.96 Tools release. The solution was extended with JD Edwards EnterpriseOne 8.97 Tools release by integrating the embedded BI Publisher reports into JD Edwards EnterpriseOne life cycle management. The solution has been further extended in JD Edwards EnterpriseOne 8.98 Tools release to support interactive reports. Interactive reports are created, managed and processed in the Oracle BI Publisher Enterprise toolset. The embedded reports continue to be created, managed and processed using the JD Edwards EnterpriseOne toolset.

BI Publisher reduces the high cost of producing, customizing, and maintaining business documents. Built on the open XSLFO (Extended standard, it provides a full range of reporting capabilities, including charts, formulas, watermarks, and graphics. Using a set of familiar desktop tools, users can create and maintain their own report formats based on data extracts from JD Edwards EnterpriseOne reports. The following example shows sample documents generated by BI Publisher:Introduction to BI Publisher for JD Edwards EnterpriseOne.

BI Publisher sample documents

The flexibility of BI Publisher is a result of the separation of the report layout from the data. The data collection is still handled by JD Edwards EnterpriseOne; however, you can design and control how the report outputs are presented using template files. At runtime, BI Publisher merges your designed template files with the report data to create a variety of outputs to meet various business needs, including:

• Customer-ready PDF documents, such as financial statements, marketing materials, contracts, invoices, and purchase orders using colors, images, font styles, headers and footers, and many other formatting and design options.
• HTML output for optimum online viewing.
• Excel output to create a spreadsheet of your report data.
• Third-party provided PDF documents. You can download a PDF document (such as a government form) to use as a template for your report. At runtime, the data and template produce a completed form.
• Flat text files to exchange with business partners for electronic data interchange (EDI) and electronic file transfer (EFT) transmissions.
• You can create batch applications using JD Edwards EnterpriseOne Report Design Aid to produce XML output that is compatible with BI Publisher.
  

Benefits of BI Publisher for JD Edwards EnterpriseOne

BI Publisher for JD Edwards EnterpriseOne enables you to:

• Create report layouts using familiar desktop applications.Embedded and Interactive BI Publisher Reporting Understanding BI Publisher for JD Edwards EnterpriseOne.
• Format batch application output .
• Automatically distribute reports email.
• Leverage a single batch report to generate multiple different end-user reports.
• Define and manage report definitions.
• Burst a report to a variety of recipients based on data-driven metrics or specified distribution lists.
  

Embedded and Interactive BI Publisher Reporting

• Embedded BI Publisher reports are created and managed using the JD Edwards EnterpriseOne toolset. In addition to the embedded reports, you have the option to create interactive BI Publisher reports using the Oracle BI Publisher Enterprise toolset.

Embedded BI Publisher Reporting

• An event in JD Edwards EnterpriseOne initiates the requirement for the report. For example, the creation of a new sales order could automatically launch the Pick Slip process.The Pick Slip process would be configured to produce a BI Publisher document that is shipped with the order. The document would be produced with no user interaction.
• The report needs to update, insert, or delete JD Edwards EnterpriseOne data. Examples of report processes that update JD Edwards EnterpriseOne data are: updating the product shipped date, advancing the sales order status, and updating the statement print date.
• The report needs to perform JD Edwards EnterpriseOne business logic. Examples of business logic include: determining the correct pricing for a product, computing an employee's salary or benefits, and calculating commissions for sales staff.

Interactive BI Publisher Reporting :

Interactive BI Publisher reporting should be used under the following circumstances:

• The requested report is not part of a standard JD Edwards EnterpriseOne business process, or the requirements for the report change over time. The following are examples of these types of reports: –The CIO requests a list of current open Account Receivables. –A manager wants to review year-to-date budget amounts compared to actuals. –A manager requests a report showing current inventory levels. –Requests for other typical ad-hoc reports.
• The report only reads JD Edwards EnterpriseOne data. The following are examples of these types of reports: –A summary of activity for a particular customer. –The current General Ledger balances for a subset of accounts. –A list of travel expenditures for a department. –A list of active suppliers.

Embedded and Interactive BI Publisher Reporting Comparison

The following table summarizes the recommendations for using the embedded and interactive reporting capabilities of BI Publisher with JD Edwards EnterpriseOne.

Scenario	Embedded	Interactive Reporting
An event within JD Edwards EnterpriseOne triggers the report: Pick Slips Invoice Print AP Checks W2	Yes	No
A non-JD Edwards EnterpriseOne event triggers the report: Budget to Actual Inventory levels Ad-hoc reports	No	Yes
An update to the JD Edwards EnterpriseOne data is performed: Update status codes Modify dates Adjust inventory quantities Create history records	No	Yes
The report only reads JD Edwards EnterpriseOne data: Customer activity General Ledger accounts Travel expenditures Summary of suppliers	Yes	Yes
The report needs to perform business logic: Calculate taxes Schedule delivery dates Calculate salaries and benefits calculations Calculate sales commission calculations	Yes	No