Is It Possible to Re-order Levels in REV_HIER_FLATTENED to be the Same As DIM_<dimension>_HIER Table

(Doc ID 2164135.1)

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)

Goal

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?

 

Solution

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