Considerations When Modifying Reports

Consider the following issues when modifying reports:

Removing Columns from the Data Model

A warning message appears in JD Edwards EnterpriseOne if you remove a column from the data model and the column is referenced by the report layout. The message indicates that you might need to adjust the layout based on the change to the data model. Oracle's BI Publisher Layout Editor then launches automatically with a column substitution wizard, which enables you to specify a substitution for the missing column.

As a workaround, use the Layout Editor to remove the column from the report layout before removing it from the data model in JD Edwards EnterpriseOne.

Note: Do not click the Sign Out link, or you will have to sign into BI Publisher manually to run One View reports during the same session.

Viewing Output Formats in BI Publisher Layout Editor

You can view only one output format at a time in the BI Publisher Layout Editor. To view a different format, use the View a list option and then select a format from the Output Format drop-down list.

Note: Do not click the Sign Out link, or you will have to sign into BI Publisher manually to run One View reports during the same session.

Viewing All Records in the Interactive Viewer

BI Publisher is designed to show a limited number of rows in the interactive report. Use the vertical scroll bar in the interactive report to see the rest of the data.

Other output formats, such as PDF, do not have this limitation.

Changes to Existing Reports

When you save the changes you make to an existing report using the Save option, the BI Publisher data model and the report definition for One View reports will be replaced but report layouts will be retained.

Blank Numeric Data

In some instances, blank numeric data in a JD Edwards EnterpriseOne grid column appears as 0 (zero) in a BI Publisher report. An example is the data dictionary item SHPN (the shipment number in P4210). SHPN does not display a value if it is zero because that is how it is configured in the data dictionary. On a Find/Browse form, a column based on a data dictionary item that has this display rule will be blank if the value is zero.

To enable data calculations, a blank numeric value in a grid column is sent to the BI Publisher server as a zero to enable data calculations. For this reason, the One View report shows a zero even though the EnterpriseOne grid column is blank.