Is It Possible to Re-order Levels in REV_HIER_FLATTENED to be the Same As DIM_<dimension>_HIER Table
Last updated on JANUARY 26, 2017
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Is it possible to re-order Level in REV_HIER_FLATTENED to be the same as DIM_<dimension>_HIER table.
After flattening a hierarchy for a given dimension (eg. ORG_UNIT_ID) the results are populated in REV_HIER_FLATTENED.
But, the levels displayed on the User Interface and that of DIM_ORG_UNIT_HIER are just opposite showing from Level 20 instead of Level 1.
Level 1 to level 17 are null.
Is it possible to re-order them in the same order from Level 1 to Level 3 instead of Level 20 to Level 17?
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