My Oracle Support Banner

"Dim Product - Assumptions (View)" Uses DIM_PRODUCT Tables Instead of Custom Dimension DIM_EPM_COA (Doc ID 2417305.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Business Intelligence Enterprise Edition (OBIEE)


Within ALM BI -> 09 ASSUMPTIONS -> PRODUCT CHARACTERISTICS report, column "Product - Assumptions"."Product Name" being referred to, its derived from "Dim Product - Assumptions (View)" view and SQL query in this view is as follows:


As per repository RPD file, "Dim Product - Assumptions (View)" is derived from dim_products_tl, dim_products_b tables and needs to be changed, as per customer requirement of using custom DIM_EPM_COA table instead, in the query.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.