38 Load, Calculate, and Retrieve Aggregate Storage Data

The most common tasks for Essbase aggregate storage (ASO) cubes involve maintaining the outline, loading and calculating data values, and retrieval. These tasks are different for ASO cubes than for block storage cubes.

Examples in this chapter refer to the aggregate storage outline for the ASOSamp.Basic cube, illustrated below.

Figure 38-1 ASOSamp.Basic Aggregate Storage Outline

The simplified aggregate storage outline is not completely expanded. A plus sign (+) node at the left of a member name indicates that the member has children that are not displayed.