Hierarchical Ordering of Members of a Hierarchy
Suppose we have a GEO dimension with 5 attributes.
“Level1 Key” is the key attribute. It corresponds to the Brick of a geographical structure.
“Level2 Name” is the Province. “Level3 Name” is the Region. “Level4 Name” is the Zone and “Level5 Name” is the total Nation.
So we have a hierarchical structure here, whose top level is “Level5 Name” and the bottom level is the “Level1 Key”. To represent this, we create a user defined hierarchy as follows.
Tags: design