Databases Reference
In-Depth Information
•
Parent
: A Parent is an outline member which has a child member or many
children members below it. For example:
QUARTER 1
is a parent of
JAN
,
FEB
, and
MAR
.
•
Child
: A Child outline member is an outline member that has a parent.
For example:
JAN, FEB,
and
MAR
are the children of
QUARTER 1
.
•
Siblings
: Sibling outline members are members that are at the same level
in the outline and share the same parent. For example:
JAN
,
FEB
, and
MAR
are siblings.
•
Descendants
: Descendant outline members are all members below a parent,
which include any children and their children. For example:
QUARTER 1
,
QUARTER 2
,
JAN
, and
APR
are the descendants of
YEAR
.
•
Ancestors
: Ancestor outline members are all members preceding a particular
member, including the parent, the parent's parent, and so on. For example,
QUARTER 1
and
YEAR
are ancestors of
JAN
.
•
Root
: The Root outline member is the top-most branch of a member tree.
For example,
YEAR
is the root member for
QUARTER 1
,
QUARTER 2
,
JAN
and
APR
. All upper-most outline members are the root members of their
respective dimension. To put it another way, the root member has no parent.
•
Leaf
: Leaf is an outline member that has no children. The leaf member is also
called the
Level 0
member. For example:
JAN
,
FEB
,
APR
, and
JUN
are the
Leaf members or nodes or the lowest level member in its part of the outline.