Databases Reference
In-Depth Information
Hierarchies
Dimensions can have one or more hierarchies of the members. Included with your
installation of Essbase, you get the sample ASO application called ASOsamp to use
as a guide when learning about ASO.
In ASO, there are two types of hierarchies:
• Stored hierarchies
• Dynamic hierarchies
An outline dimension in an ASO database can have any number of members and
these members can only be set as either stored members or dynamic members.
They can even have both of the hierarchies. In order to set the dimension to have
both types of hierarchies, you need to enable
Multiple Hierarchies Enabled
. If no
hierarchy is defined, then by default it is tagged as
Stored
hierarchy.
To enable multiple hierarchies, follow these steps:
1.
Right-click on the dimension or member name you wish to enable
the multiple hierarchies on. Click on
Edit member properties…
.
