View Modification In EIS eXpress Reports

View Amendments:

If you amend a view once it has been imported, i.e. add, rename or remove a column from the view you must update the view definition in EiS before the report will reflect the changes.

Responsibility:     XXEIS eXpress Developer

Path:           Setup => Data Sources => Search by

Adding Columns To Eis Reports

If you have added columns to the view you will need to call the view back in the “Data Sources” screen and use the “Show Object Changes” button to review columns that can be added to the view.

The top section of the screen will now show you columns that can be imported into the Object (view), select all of the columns and click the import button.

The new columns will now be available for selection in the report.

Removing Columns To Eis Reports:

If you have removed or renamed columns in the view it is equally as import to delete them from the view definition in EiS as well. Call the view back in the “Data Sources” screen as per above and use the “Show Object Changes” button to review columns that have been removed from the view.

The second section of the screen will show all of the columns that no longer exist in the Oracle view and allow their deletion. Select them all and click “Delete”

Note: Deleting a column here will remove it from the report, if you have a column selected for use in a report that no longer exists in the underlying Oracle view the report will error with “invalid identifier” message. Failure to remove columns from EiS after removing them from the Oracle view could result in “Power Users” thinking they are valid and getting the aforementioned issue when they run the report.