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

(Doc ID 2417305.1)

Last updated on JULY 02, 2018

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)
ALM BI

Symptoms

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:

SQL>

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.

Cause

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