Introduction to Financial Reporting Model

Data Framework (DF) is a data life cycle framework that provides the Temenos Transact customers to realise the huge potential value of the transactional data generated by Temenos Transact. This is achieved by using a read-only Dimensional (DIMal) database optimised for near real-time predictive analytics and modelling tools.

DF provides the infrastructure to create and maintain a read-only database in near real time using Extract Transform and Load (ETL) process, to ensure a database which is optimised for reporting. It also provides the ability to design and execute queries against the read-only database. It leverages the Temenos Transact Interaction and Integration frameworks, so that the data is available in near real-time. Read Data Framework topic for more information on the Data Framework reporting components and product configuration.

The Operational Reporting database (DB) is deployed as a series of reporting models targeting different business domain such as:

• Customer and Account Balance Reporting model (product - DA).
• Financial Reporting model (product - DZ).

Financial Reporting Model

The Financial Reporting model (DZ) is a business domain and is available from 201612. This model is packaged under the Temenos DZ module and is licenced together with the Data Framework Reporting Model (DF) module.

This model is designed specifically for the purposes of querying the information of general ledger movements, all necessary information to produce financial reports and queries. This includes a full history of journal movements, contract and general ledger balances, with capability to drill down from general ledger to the underlying movement or contract balance. The model also includes the necessary infrastructure to support the update of the read-only database in near-real time, and the ability to define and execute enquiries in the read-only database.

Understanding the Components of the DZ Module

The DZ module consists of the following components.

• The Dimensional (DIMal) data model.
• A set of Integration Framework (IF) events.
• A set of transformation rules (execute transform and load).
• Query and report.