11.3 Hard-Coded Dimension Members

The node-level reporting lines (including higher-level nodes) of the reporting line hierarchy that are used in the OBIEE components (Web Catalog and RPD) are mentioned below for reference.

These reporting line codes should not be modified.

Table 11-2 Reporting Line Dimensions

Catalog/RPD	Repline Code	Repline Name
catalog	107001	Management Reporting
catalog	107002	Income Statement
catalog	107003	Balance Sheet
catalog	98000	Net Income Before Taxes
catalog	51000	Cash
catalog	54000	Trading Assets
catalog	61000	Investments
catalog	63000	Fixed Assets
catalog	64000	Other Assets
catalog	60000	Loans and Advances to Customers
catalog	72000	Total Liabilities
catalog	74900	Allocated Capital
catalog	77000	Shareholders Equity
catalog	72000	Total Liabilities
catalog	75000	Share Capital
catalog	76000	Reserves
catalog	60000	Loans and Advances to Customers
catalog	68000	Customer Liabilities
catalog	85000	Net Interest Revenue
catalog	85100	Commission
catalog	85200	Fees
catalog	91910	Credit Losses
catalog	91920	Recoveries of amounts previously written-off
RPD	95000	Operating Income before Taxes
RPD	99500	Provisions for Credit Losses
RPD	91910	Credit Losses
RPD	107100	Number of Customers
RPD	52000	Interest-bearing Assets
RPD	74900	Allocated Capital
RPD	88000	Non-Interest Revenue
RPD	107120	Number of Closed Customers
RPD	83000	Credit for Float
RPD	82100	Interest Income
RPD	91920	Recoveries of amounts previously written-off
RPD	107300	Attrition Rate
RPD	60000	Loans and Advances to Customers
RPD	85000	Net Interest Revenue
RPD	83200	Interest Expenses

Other Dimensions

The dimensions other than the hardcoded reporting line dimensions are as follows:

• Run Dimension is hardcoded with a value zero.
• Legal Entity and Line of Business are hardcoded to -1 in the initial load. When the custom dimensions are added into FSI_D_MANAGEMENT_LEDGER and FACT tables, the corresponding values are used in the reports.

Reporting Currency Calculation

The base currency values are converted into reporting currency and are populated to RCY columns of Fact table using FSI_EXCHNG_RATE_DIRECT_ACCESS or FSI_EXCHANGE_RATE_HIST tables. In these tables, data should exist for the available currency combinations for the particular FIC_MIS_DATE column, for which the user is running the fact transformations that are FCT_LEDGER_STAT and FCT_MGMT_REPORTING tables. In EFPA, by default exchange rate is calculated by referring FSI_EXCHNG_RATE_DIRECT_ACCESS. However, it can be configured in the SETUP_MASTER table to use FSI_EXCHANGE_RATE_HIST if needed.

Currency Type: OFS EFPA BI reports work for Local, Base, and Reporting currencies.