"Dim Product - Assumptions (View)" Uses DIM_PRODUCT Tables Instead of Custom Dimension DIM_EPM_COA
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)
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.
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