How to Propagate Multiple Product Hierarchies to the BI Layer in OFSAA
(Doc ID 1626468.1)
Last updated on JUNE 11, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing 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.
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