ALMBI Product Characteristics Analysis Report Only Displays Products Which Are Configured at Child Level (Leaf Level), Node(Parent) Level is Not Displayed
(Doc ID 2276319.1)
Last updated on MARCH 22, 2019
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 8.0.2 to 8.0.5 [Release 8]
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'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document