Databases Reference
In-Depth Information
With the
Total Vehicles
dimension completely expanded, we see all of the child or
descendent members. We now know that we have reached the bottom level of the
dimension because there is no child indicator (
<n>
) next to the member names.
An Essbase outline dimension is the upper-most member in the
multidimensional hierarchical database structure. The dimension member
can have unlimited child members but has no parent member. The child
member can be a child member of the dimension parent and can also be
a parent or child to other members. Members, those of which are not at
the top level as dimension members, can have virtually unlimited child
members while at the same time being a child member themselves.
Outline members that share the same parent are called siblings. Essbase
is just one big happy family!
Outline member descriptors
Here, we have listed the Oracle Essbase database outline members' descriptors.
Please read this section carefully. Just about everything you do that pertains to
loading data, calculating data, and dimension building with data will depend
on your firm grasp of these key data relationship elements:
• Parent
• Child
• Siblings
• Ancestors
• Descendants
• Root
• Leaf
• Generation
• Level
Let's use the
Time
dimension as the outline example used to help in describing
the definitions for these member descriptors. Please note that the
Time
dimension
contains the calendar periods used in the Esscar system.
