How to Propagate Multiple Product Hierarchies to the BI Layer in OFSAA
Last updated on JANUARY 05, 2018
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)
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.
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