What Are a Physical Hierarchy's Properties?

This topic provides information about the properties that you assign to your imported, added, or aliased physical hierarchies.

Property	Description
External Name	Essbase and Oracle EPM Cloud Displays a user-friendly name assigned to a cube table in the Essbase or Oracle EPM Cloud application. This is the name used when referencing the cube table in physical SQL queries. If you add or change this value it must match the external name defined in the data source's application.
Dimension Name	Essbase and Oracle EPM Cloud (Dimension Unique Name) Displays the dimension that the hierarchy belongs to.
Dimension Type	Essbase and Oracle EPM Cloud Identifies if the hierarchy belongs to a time dimension, measure dimension, attribute dimension, or other type of dimension.
Hierarchy Type	Essbase only Identifies the type of hierarchy: Fully balanced - A level-based hierarchy with no unbalanced or skip characteristics. Corresponds to a level-based hierarchy in the logical layer. Unbalanced - Also called ragged. A hierarchy where the leaves (members with no children) don't necessarily have the same depth. Corresponds to a level-based hierarchy with the Ragged option selected in the logical layer. Ragged balanced - Also called skip. A hierarchy with members that don't have a value for a particular ancestor level. Corresponds to a level-based hierarchy with the Skipped Levels option selected in the logical layer. Network - This hierarchy type isn't used. Ragged stretched - A hierarchy with members that don't have a value for a particular ancestor level, and not all members at the same level have the same parent level directly above them. Value - Also called parent-child. A hierarchy of members that all have the same type. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of the hierarchy. Corresponds to a parent-child hierarchy in the logical layer. For level-based hierarchies with both unbalanced and skip-level characteristics, choose either Unbalanced or Ragged balanced as the physical hierarchy type. Then make sure that both Ragged and Skipped Levels are selected for the corresponding logical dimension in the logical layer.
Parent Key	Oracle EPM Cloud only The column in the hierarchy that identifies the member's ancestor.
Member Key	Oracle EPM Cloud only The column in the hierarchy that identifies the member.
Default Member type ALL	Oracle EPM Cloud only This option isn't used.
Use unqualified member name for better performance	Essbase and Oracle EPM Cloud Select this option when member names including aliases are unique in the hierarchy so that the Oracle query engine can take advantage of specific multidimensional expression (MDX) syntax to optimize performance.