How to Propagate Multiple Product Hierarchies to the BI Layer in OFSAA
(Doc ID 1626468.1)
Last updated on DECEMBER 12, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 to 7.3.5 [Release 7 to 7.0]Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 6.0 to 6.1 [Release 6]
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.0 to 6.1 [Release 6]
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
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
| Goal |
| Solution |