41.1 Extract the Data Model Report from the erwin Data Modeler application

To extract the Data Model Report from the erwin Data Modeler application, follow these steps:

1. From OFSAA Home, select Oracle Financial Services Data Foundation, select Common Components, select Utilities, and then select Compare Data Model Reports.

   Figure 41-1 Navigation to the Compare Data Model Reports page

   
   

   

   
   
2. The Compare Data Model Reports page is displayed.

   Figure 41-2 Compare Data Model Reports page

   
   

   

   
   
3. To browse and select the old data model report excel file, use Choose File associated with the Select Old model file label. To browse and select the new data model report excel file, use Choose File associated with the Select New model file label respectively. To select a different Data Model Report, click Reset.

   Note:

   The old data model report Excel file and new data model report Excel file must be in the same format and the file extension must be .xlsx.

   Figure 41-3 Select the old and new data model reports

   
   

   

   
   
   The Compare Only Common Tables option is No by default. Select Yes only if required.

   Note:

   Compare Only Common Tables with option Yes is used when comparing the Data Model Report of different OFSAA applications. The Report field is different for each OFSAA application and only common fields are required for comparison.
4. To compare the old and new data model report, and generate the Data Model Difference Report, click Compare. The Download Model Difference Report link appears. To download the Data Model Difference Report, click the Download Model Difference Report link.

   Figure 41-4 Generate the Data Model Difference Report

   
   

   

   
   
5. Save the file.