My Oracle Support Banner

AMHM Limitation Cannot Host Multiple Sets of Attribute Values for a Single Dimension Member (Doc ID 2453405.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
AMHM (Attributes Members Hierarchies Module)
Data Relationship Management (DRM)
Hierarchy Loader
Dimension Loader


AMHM Limitation cannot host multiple sets of attributes values for the same attribute for the same dimension member.

In the DIM_<DIMENSION>_INTF tables of the dimension loads, there is no Hier_Object_name column in the STG_*_ATTR_INTF or DIM_*_ATTR tables. This is a major functionality issue as it is not possible to load different hierarchies having different attribute values for same nodes.

For example:
For Org Unit dimension, have three separate hierarchies each for Actuals, Budget and Forecast. Now all three hierarchies have same node 35567 - Some department name with an attribute OSR values as Provider in case of Budget, but in case of Actuals it may still be Non-provider.

If loading the hierarchies together at the Dimension id level, how to fulfill this requirement of having the correct OSR value populated for Actuals run and Budget run?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.