Databases Reference
In-Depth Information
Level
Level also refers to the location of a member in the outline dimension, but it's
counting starts from the leaf node all the way upto the root. The leaf node is called
Level 0
, the parent of the leaf node is
Level 1
, and its parent is
Level 2
, and so
on until we reach the root member.
Looking at the example above, you can ask the question,
"In this outline, can the
Quarter 4
member be considered
a
Generation 2
member and a
Level 1
member and can
the DEC member be considered a
Generation 3
member
and a
Level 0
member?" The answer is a resounding yes!
The Level approach to traversing your database outline
is a bottom-up approach. For example, the
Level 0
is
the lowest level or the leaf node level. The
Level 1
would
be the next level higher towards the root member.
In the example below,
JAN
,
FEB
,
MAR
, and
APR
are all
Level 0
.
QUARTER 1
,
QUARTER
2
,
QUARTER 3
,
QUARTER 4
are
Level 1
members, and
YEAR
is a
Level 2
member.
LEVEL 2 Years
LEVEL 1
9
Quarter 1
LEVEL 0
9
JAN
LEVEL 0
9
FEB
LEVEL 0
9
MAR
LEVEL 1
9
QUARTER 2
LEVEL 0
9
APR
LEVEL 0
9
MAY
LEVEL 0
9
JUN
LEVEL 1
9
QUARTER 3
LEVEL 0
9
JUL
LEVEL 0
9
AUG
LEVEL 0
9
SEP
LEVEL 1
9
QUARTER 4
LEVEL 0
9
OCT
LEVEL 0
9
NOV
LEVEL 0
9
DEC