Databases Reference
In-Depth Information
2.
On the
Member Properties
screen, under the
Hierarchy
section,
select
Hierarchies Enabled
from the
Hierarchy
list box:
Stored hierarchies
Using
Stored
hierarchies, the data is aggregated based on the outline structure.
The data aggregation and data retrieval is faster. There are a few restrictions
when using
Stored
hierarchies:
• Stored hierarchies cannot have member formulas.
• Stored hierarchies can have the
no-consolidation (~)
operator for
Label-only
members. A member that is label only is merely in the outline as a place holder
or to be informational and does not store data. A good example of this is our
Calendar Periods
dimension. While the root member
Calendar Periods
is
useful to have for information, the data would make no sense rolled upto
this level.