and age level
The All level is a special, optional level
, which appears in all the
hierarchies of a dimension
. If defined, this level contains one member
, the All member, which
corresponds to all records in the cube. You can use the All member
to create a summary line in a pivot table.
Informally (although not in this documentation), the phrases
drill down and drill through
are sometimes used interchangeably, and it is wise to double-check
which phrase is intended.
An organization of levels
. Levels belong to hierarchies (which belong to dimensions
). A hierarchy
can contain only single level or can contain multiple levels. If it
contains multiple levels, the higher
levels of the
hierarchy are less granular then the lower
That is, each member
a higher level contains a larger set of records than does a member
of a lower level.
In casual usage, a higher level is called the parent of the
lower level. However, it is useful to remember that the hierarchy
is a actually a hierarchy among members. Thus it is more accurate
to state that a member of the higher level is the parent of one or
more members of the lower level. Conversely, any member of a lower
level is the child of exactly one member of the higher level.
and time level