ALMBI Product Characteristics Analysis Report Only Displays Products Which Are Configured at Child Level (Leaf Level), Node(Parent) Level is Not Displayed
Last updated on JUNE 23, 2017
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 8.0.2 and later
Information in this document applies to any platform.
ALMBI - Asset Liability Management Business intelligence
ALM - Asset Liability Management
ALMBI Assumptions Tab -- ALM Product Characteristics report.
In current instance, 90% of ALM product characteristics are configured at Product Node (Parent) Level.
In the table FSI_M_PROD_CHARACTERISTICS, product_id column has node values & leaf values [only configured leaf values].
In ALMBI 8.0.2, ALM Product Characteristics Analysis Report only displays products which are configured at Child Level (Leaf Level). Configuration which is done at Node(Parent) level is not displayed.
The following query can help in better analysis:
from DIM_PRODUCT T11170 /* Dim Product */,
DIM_CURRENCY T11146 /* Dim Currency */,
FSI_M_PROD_CHARACTERISTICS T20430 /* Fact Product Characteristics */,
FSI_M_OBJECT_DEFINITION_TL T18138 /* Dim Object Definition (Leaf Characteristics) */,
FSI_M_OBJECT_DEFINITION_B T20088 /* Dim Object Definition Base(Folder) */
where (T11146.V_ISO_CURRENCY_CD = T20430.CCY_CD and
T11170.N_PRODUCT_ID = T20430.PRODUCT_ID and
T18138.OBJECT_DEFINITION_ID = T20088.OBJECT_DEFINITION_ID and
T18138.OBJECT_DEFINITION_ID = T20430.PROD_CHAR_SYS_ID and
T20088.FOLDER_NAME = 'OFSALMSEG'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms