How To Ensure That No 'Leaf' Dimension Members Are Left Out Of A Hierarchy?
Last updated on OCTOBER 04, 2016
Applies to:Oracle Enterprise Performance Foundation - Version: 220.127.116.11
Information in this document applies to any platform.
Is there a way to ensure that no 'leaf' dimension members are left out of a hierarchy?
Oracle® Enterprise Performance Foundation
Part No. B14460-03
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?
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