45 APPENDIX D: Template to Generate Data Dictionary and Download Specification for erwin 2019R1 or a higher version

OFSAA data models for this release have been designed and released on the 2019R1 or a higher version of erwin. However, if there is a requirement to upgrade to the latest version of erwin (2019R1 or a higher version series), the existing procedure to generate DL specification using the published report templates fails in the lower version. This is because of architectural changes between the two erwin versions. This chapter provides information about the procedure to generate data dictionary and download specification for erwin 2019R1 or a higher version, for all OFSAA data models qualified on OFSDF 8.1.2.0.0.

Upgrade the data model to 2019R1 or a higher version series before initiating generation of the DL specification.

Download the excel based template OFSAA Data Model Dictionary Template.xls and follow the steps mentioned below. This template is compatible with all the OFSAA data models that are qualified with OFSDF version 8.1.2.0.0 and erwin 2019R1 or a higher version.

1. Ensure that the erwin Data Modeler version is erwin 2019R1 or a higher version.
2. Ensure that macros are enabled in this excel before execution.
3. Open the OFSAA Data Model in erwin 2019R1 or a higher version before executing this template.
4. Click UDP selection Menu to launch the UDP Selection form.
5. Select the correct application UDPs (optional).
6. Click Generate Report.
7. On successful execution, the following message is displayed: Report generation is Complete.
8. The download specification and the data dictionary report are available in the OFSDF Download Specifications document in ʺOFSAA_Download_Specʺ worksheet.

Note:

To generate report for two application UDPs such as ʺBASEL_III_USA_ADVNCDʺ and ʺORʺ , you need to manually remove the extra characters from the UDP name in the data model else the execution throws an error.