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.
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.
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.