Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Hyperion Essbase Dimension Terminology

Posted by Dylan Wan on June 20, 2008

I found the the language used in Hyperion Essbase documentation is very useful for describing the dimension hierarchy. To communicate effectively, sometime we need precise teams to describe things. The terms defined in the Hyperion Essbase documentation helps.

Member: A node within a hierarchy.

Root: The root is the top member in a hierarchy.

Parent: A parent is a member that has another member below it.

Child: A child is a member that has a parent above it.

Sibling: Siblings are child members of the same immediate parent, at the same generation.

Descendant: Descendants are all members in branches below a parent.

Ancestor: Ancestors are members in branches above a member.

Leaf: Leaf members have no children.

Generation: A generation refers to a level within a dimension. A root branch of the tree is generation 1. Generation numbers increase as you count from the root toward the leaf member.

Level: Level also refers to a branch within a dimension; levels reverse the numerical ordering used for generations. Levels count up from the leaf member toward the root. The root level number varies depending on the depth of the branch. All leaf members are level 0. The parents of leaf members are level 1. The level number of a member varies depending on the branch.

Many are similar to the terms used in PeopleSoft Tree Manager, but Hyperion Essbase separates the Generation Number from the Level Number. The term Descendant and Ancestor are useful.

PeopleSoft Tree Manager, on the other hand, have its special notions of Summer Tree, Winter Tree, and Spring Tree.

Reference

1. Hyperion Essbase, Database Administrator’s Guide – Understanding Multidimensional Databases.

Advertisements

3 Responses to “Hyperion Essbase Dimension Terminology”

  1. […] Database Management wrote an interesting post today onHere’s a quick excerpt I found the the language used in Hyperion Essbase documentation is very useful for describing the dimension hierarchy. To communicate effectively, sometime we need precise teams to describe things. The terms defined in the Hyperion Essbase documentation helps. Member: A node within a hierarchy. Root: The root is the top member in a hierarchy. Parent: A parent is a member that has another member below it. Child: A child is a member that has a parent above it. Sibling: Siblings are child […]

  2. article directory, free backlinks…

    […]Hyperion Essbase Dimension Terminology « Dylan’s BI Study Notes[…]…

  3. motorcycle performance tuning…

    […]Hyperion Essbase Dimension Terminology « Dylan’s BI Study Notes[…]…

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s