1. User Guide
  2. Introduction to ALM BI
  3. Features and Components of ALM BI

2.1 Features and Components of ALM BI

Oracle Asset Liability Management Analytics (ALMBI) is a business intelligence application that integrates robust Oracle Business Intelligence (OBIEE) capabilities with the Asset Liability Management (ALM), Funds Transfer Pricing (FTP) results, thereby unleashing the power of back-office data and turning it into fully operational intelligence.

The features of ALMBI application are as follows:

  • Wide functional coverage for ALM, FTP, intelligence.
  • Designed for performance in heavy data volume environments.
  • The low total cost of ownership, efficient data movement, and template-like design to ease implementation.
  • Unleash the power of Oracle Financial Services Analytical Applications (OFSAA) data content; extend the wealth of back-office data to executives, risk managers, finance, and treasury with role-based dashboards, driving insight into interest rate risk and liquidity risk management through powerful analytics.
  • Pervasive, compelling, and actionable insight with comprehensive drill-down paths and analysis, increasing alignment, and effectiveness.

The ALMBI application is comprised of the following components:

  1. OFSAA ALMBI Reporting Mart (Physical Data Model)
    • Many ALM related relational database tables optimized for reporting and analysis.
    • Results from each ALM process are consolidated into a single reporting table allowing for comparative reporting.
    • Historical results are retained for each process, allowing for a period over period and trend reporting.
    • Results are stored in both base currency and any reporting currency specified by users during processing.
    • Account-level data is (optionally) consolidated into a series of application-specific Account Summary tables, supporting drill-down to the finest grain of detail.
    • Audit data, such as detail cash flow information and rate outputs, are additionally stored in the ALMBI Data Mart.
  2. Data Movement Processes
    • Data movement processes are provided to populate the required data into the ALMBI Data Mart. Data Movement is accomplished through the use of Table-to-Table (T2T) functionality and Procedural Language or Structured Query Language (PL/SQL or PLSQL) procedures.
    • Data Movement processes can be executed directly through a batch process using the Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) or through a Simplified Batch process. These processes are detailed in the following sections.
  3. ALMBI OBIEE Repository
    • ALMBI specific OBIEE repository file is included with the ALMBI application, which provides the mapping of the physical data into the ALMBI Business Model.
    • This repository defines the necessary data objects, join relationships, and calculated items needed for ALMBI Reporting.
  4. ALMBI OBIEE Web Catalog
    • The ALMBI specific OBIEE Web Catalog provides out of the box dashboards and seeded reports which provide users with a head-start in developing their organization-specific ALM, FTP, and related BI content.