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)
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
Million Knowledge Articles and hundreds of Community platforms