How to Propagate Multiple Product Hierarchies to the BI Layer in OFSAA (Doc ID 1626468.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Asset Liability Management Analytics - Version 6.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Business Intelligence (BI)
Slowly changing dimension (SCD)
Attributes Members Hierarchies Module (AMHM)

Goal

How can you add a second hierarchy to the BI Layer for use in Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) or Asset Liability Management Analytics (ALMBI)?  Can multiple hierarchies be created for the same dimension?

You need to add a 2nd hierarchy to the dimension table DIM_<dimension> when running the SCD.

Solution

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