How To Ensure That No 'Leaf' Dimension Members Are Left Out Of A Hierarchy? (Doc ID 403550.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
Information in this document applies to any platform.

Goal

Is there a way to ensure that no 'leaf' dimension members are left out of a hierarchy?

REFERENCE SOURCES:
Oracle® Enterprise Performance Foundation
User’s Guide
Release 11i
Part No. B14460-03
July 2006
Page 3-13

5. In the Hierarchy Type box, select one of the following:
• Open — This is the standard hierarchy type. There are no special functions
or restrictions associated with it.
• Reconciliation — Reconciliation hierarchies are used in conjunction with members for which the RECON_LEAF_NODE_FLAG is set to Y. These hierarchies prohibit children from being added below nodes for which the member is defined as a leaf. Such hierarchy types are typically used to ensure that all leaf-level members are included in a specific hierarchy.

How is this done? A reconciliation hierarchy does not force all leaf members (those with RECON_LEAF_NODE_FLAG = Y) to be included in the hierarchy.  Also, the top node selected for a hierarchy has no relationship to its children until they are added into the hierarchy.  How do you ensure that all 'leaf' members for a particular dimension have been included in the hierarchy?

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