17   OFSAA Features

This chapter provides an understanding of the AAI components used in the solution and dimensional mapping.

Topics:

·        OFSAA Infrastructure

·        Business Metadata

·        Derived Entity

·        Rules Framework Features

·        Dimension Mapping 

Regulatory Reporting (REG REP) Solution configures the data handoff structure to Lombard using metadata. The following sections provide details on datasets, measures, hierarchies, and Derived Entities. Multiple derived entities are linked to a specific regulatory schedule. You can modify the configuration using the OFSAA infrastructure. Additionally, the metadata route provides traceability from reporting elements to the data elements used.

OFSAA Infrastructure

OFSAA Infrastructure includes the facilities for creating and maintaining dimensional reference data, interest rate, and currency exchange rate data, and process tuning data. Additionally, OFSAA Infrastructure includes functionality for building and maintaining rules that can be used by any Oracle Financial Services Analytical Application. These common rule objects include:

·        Expressions

·        Hierarchies

·        Filters

The analytical applications that you see on the Left-Hand Side (LHS) of the Financial Services Applications home page are depending on your logon privileges and on the OFSAA modules that are installed for your environment.

Figure 250: Metadata Management Landing Page

Business Metadata

In addition to Derived Entity, REG REP uses the following OFSAA features to create the business metadata. For details on the features, see the OFS Analytical Applications Infrastructure User Guide.

·        Hierarchies: Some OFSAA dimensions support hierarchies. Hierarchies can be used to provide sophisticated stratification for either processing or reporting purposes. For example, an organizational hierarchy can start with a Division level containing Western Region, Eastern Region, and Southern Region; the next level down within the hierarchy can be state or county. A product hierarchy can begin with branches for Asset vs. Liability vs. Service products; under the Asset branch, you can define additional branches for Mortgage Lending, Commercial Lending, Consumer Lending, and so on.

·        Measures: Business Measure refers to a uniquely named data element of relevance that can be used to define views within the data warehouse. It typically implies aggregated information as opposed to information at a detailed granular level that is available before adequate transformations.

·        Business Processor: It refers to a uniquely named data element of relevance that can be used to define views within the data warehouse. It typically implies aggregated information as opposed to information at a detailed granular level that is available before adequate transformations.

·        Datasets: It refers to a group of tables whose inter-relationship is defined by specifying a join condition between the various tables. It is a basic building block to create a query and execute a data warehouse for a large number of functions and to generate reports.

Derived Entity

It is the primary component of OFSAA used for OFSDF Interface with Lombard Risk for APRA/MAS/RBI. Regulatory Reporting (REG REP) Solution uses Derived Entity to create a physical materialized view, which is then queried by Lombard using pre-set data hand-off templates. An Entity refers to a table in which data is stored. Derived Entity within the infrastructure system facilitates you to define entities that are populated through a series of data transformation processes resulting from an existing Data Set or a Source Application. An Entity can be used to define other Business Metadata such as measures, hierarchies, dimensions, data sets, and cubes.

Derived Entities comprise the following:

·        Measures

·        Hierarchies

·        Datasets

Ensure to define the above components within OFSAA before configuring the derived entity and select Materialized View property in Derived Entity. This property creates the derived entity as materialized views.

1.     Navigate to Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions, select Metadata Management, and then select Derived Entity. The existing derived entities Summary Screen is displayed. You can Add a new Derived Entity and Edit, View, Delete, or Copy an existing Derived Entity.

Figure 251: Derived Entity Summary Page

2.     Click the Add button to create a new Derived Entity.

Figure 252: Derived Entity User Interface

Creating Derived Entity

Derived Entities must have Code, Short Description and Source Type mandatory dimensions as shown in Error! Reference source not found.. The rest of the structure of the derived entity can vary depending on the dimensions present. A metadata configuration table is present in AgileREPORTER to link the name of the column in the Derived Entity and dimension that is referred to in the Dimension Mapping Process.

Derived entities have data for the ‘Final Reporting Run’ only, which is reported to the Regulatory, and are refreshed for the latest hand-off date.

A metadata configuration table is maintained within AgileREPORTER to capture the derived entities that supply data for each schedule.

For more information on creating a Derived Entity, see the OFS Analytical Applications Infrastructure User Guide.

Rules Framework Features

OFSDF Interface with Lombard Risk for APRA/MAS/RBI uses the following Rules Framework of OFSAA. For more information about the features, see the OFS Analytical Applications Infrastructure User Guide.

·        Rules: Financial institutions require constant monitoring and measurement of risk to conform to prevalent regulatory and supervisory standards. Such measurement often entails significant computations and validations with an organization’s data. Data must be transformed to support such measurements and calculations. The data transformation is achieved through a set of defined rules.

·        Regulatory Reporting Solution uses Rules for reclassification of dimensions.

Dimension Mapping

Each cell reference is mapped to a set of Dimensions and Measures. This mapping is documented in excel and then converted to a Decision table through an offline utility provided by AgileREPORTER. A decision table is a metadata object within AgileREPORTER that stores the criteria for deriving value for each cell reference. The metadata is packaged for the regulatory report as part of the OFS Risk Regulatory Solution. The decision table process within AgileREPORTER reads the metadata and derived entity published by OFSAA to populate data required for returns for the specified date and legal entity.

The following table is an example of dimension mapping. Each cell reference is mapped to a set of dimension members and measures. If a dimension is left empty for a cell reference, it indicates that it is not participating in the mapping process. If there are multiple mappings for a cell reference, then the value of this cell can come from any of these criteria.

The decision-mapping table is processed against the contents of the derived entity to Reporting Data. Each record of the Derived Entity is matched against the criteria specified in the decision table to identify the cell reference and derive return data (such as cell reference and cell value).

The following table is derived after converting the dimension member and measure names into corresponding dimension member codes (not surrogate keys) and measure codes. This Decision Table Mapping is provided for each decision table in excel format as per the template. AgileREPORTER converts the Decision Table Mapping present in excel into configuration entries within their schema.

   Table 43: Dimension Mapping Example

NOTE:   

All the Dimension Member Codes that are used in the decision table are preceded by OFSAA and cannot be modified. Therefore, if you have other member codes in the dimension, then you must re-classify them by using re-classification rule post load, or value-code mapping during load.

Decision Tables must be prepared closer to the report submission period. In some cases, reclassification of multiple dimensions that result in a single unified Reporting Dimension must be performed in order to address the complexity of the decision table. Reclassification rule is defined in OFSAA and packaged as part of the OFSAA Risk Regulatory Reporting (REG REP) Solution.

In some cases, certain sections of the schedule or the entire schedule can be a list of data rows without any mapping to a fixed set of dimension members. For example, Top 20 counterparties, List of Available for Sale (AFS) - securities. In such cases, since there are no cell references, decision table mapping specifies the names of dimensions and measures of derived entities in the ‘sheet’ column or ‘row’ column of the template.

NOTE:   

As a part of the solution, metadata exists as ready-to-use or pre-configured with the installer.