Cannot Order Top Level of Multiple Top Hierarchy Using Dimension Hierarchy Loader (Doc ID 417394.1)

Last updated on NOVEMBER 28, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.

Symptoms

In Enterprise Performance Foundation Administrator, after loading a Hierarchy with multiple tops using the Dimension Hierarchy Loader program, the top levels are not displayed in the correct order in the interface.

In the FEM_xxxxx_HIER_T table, the display order was as follows:

"PARENT_DISPLAY_CODE" -- "CHILD_DISPLAY_CODE" -- "DISPLAY_ORDER_NUM"
"TOTAL AST" -- "TOTAL AST" -- "1"
"TOTAL LBL" -- "TOTAL LBL" -- "2"

However, in "Configuration Rules" → "Dimension" → "Hierarchy", the top levels are in a different order:

TOTAL LBL
TOTAL AST

Cause

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