11.1 Why is External Engine Required

OFSDF has an Integrated Data Model. Application-specific Outputs or Results Tables are populated by the respective Applications when an OFSAA Application along with OFSDF is installed. Application-specific outputs are consumed by other Applications and for the Regulatory Reporting purposes. However, when an OFSAA Application is not installed with OFSDF, then there is no data in the respective Application-specific Result Tables, which are required for some other installed application to work.

In such a scenario, the Customer was sourcing the data from the Application-specific External Analytical Engine (for example, from OFS IFRS) into the Result Tables directly. However, there are elements such as Surrogate Keys and Amounts represented in different currencies, which are not available directly in the Source System and are derived or computed using OFSDF specific logic. Therefore, the Customer used to do the following:

1. Extract the data from the External Analytical System.

2. Write an ETL to lookup the OFSDF corresponding Dimension Tables to get the required Surrogate Keys, do the currency conversion for the Amount attributes wherever required, and then populate the data set in the Application-specific Result Tables.

3. Update the ETL for each release to accommodate the new changes of the Result Tables.