Stored Hierarchies

Members of stored hierarchies are aggregated according to the outline structure. Because aggregate storage databases are optimized for aggregation, the aggregation of data values for stored hierarchies is very fast. To allow this fast aggregation, members of stored hierarchies have the following restrictions:

Stored hierarchies have restrictions on label only members. See Table 192, Outline Differences Between Aggregate Storage and Block Storage.

In Figure 156, Aggregate Storage Outline Displaying the Alternate Hierarchy High End Merchandise on the Product Dimension, the All Merchandise hierarchy and the High End Merchandise hierarchy are stored hierarchies. The All Merchandise member and the High End Merchandise member are the tops of the hierarchies and are both tagged as top of a stored hierarchy.

  To specify a stored hierarchy, tag the top member of the hierarchy as top of a stored hierarchy using a tool:

Tool

Topic

Location

Administration Services

Defining Hierarchies in Aggregate Storage Outlines

Oracle Essbase Administration Services Online Help

MaxL

import database

Oracle Essbase Technical Reference

The following members can be tagged as top of a stored hierarchy:

The dimension tagged as accounts is automatically considered a dynamic hierarchy. You cannot specify the accounts dimension as a stored hierarchy.