HIERSHAPE

The HIERSHAPE function identifies if a hierarchical dimension has a specified shape.

Return Value

BOOLEAN

Syntax

HIERSHAPE(parent-relation[(qdr)] {LEVEL | RAGGED | SKIPLEVEL | REGULAR} USING levelrel -

[INHIERARCHY inhvalueset] LEVELORDER levelvalueset)

Parameters

parent-relation: A text expression that is the name of the child-parent self-relation for the hierarchical dimension. (See "Parentrel Relation".)
qdr: A text expression that is the name of a QDR that qualifies parent-relation.
LEVEL: This option determines of all of the members are part of the same level as defined by the levelrel.
RAGGED: A hierarchy where leaf-nodes are located at different levels within the hierarchy.
SKIPLEVEL: A hierarchy where one or more leaf nodes link to a higher-level parent above its next most obvious level.
REGULAR: A traditional level-based hierarchy where each child has a parent at the next level up in the hierarchy.
levelrel: A text expression that is the name of the level relation for the hierarchical dimension. (See "Levelrel Relation".)
inhvalueset: A text expression that is the name of the inhier valueset for the hierarchical dimension. (See "Inhier Valueset or Variable".)
levelvalueset: A text expression that is the name of the hierlevels valueset for the hierarchical dimension. (See "Hierlevels Valueset".)

Usage Notes

Star-consistent Hierarchies

A dimension is "star consistent" when the hierarchies it represents can be implemented as a star table (that is, when a single column defines each level so there is no partial membership in a level based on hierarchy). A dimension is "star inconsistent" when it cannot.For example, assume there is a dimension with members A, B, C, D. When some customer have a "mid" level consisting of A and B in hierarchy 1 and C and D in hierarchy 2. This dimension is star inconsistent because in a star table, you would only have a single column to represent the "mid" level and its inclusion means that both hierarchies would contain all the members of that level.