Retrieve Aggregate Storage Data

Data retrieval (query) from Essbase aggregate storage (ASO) cubes, as with block storage (BSO) cubes, can be done using Smart View, MDX, MaxL, Report Writer, or other grid clients. Some differences should be expected between ASO and BSO queries.

The following programs and tools enable data retrieval from aggregate storage cubes:

Smart View
MDX queries
The export data using report_file MaxL statement

Note:

Commands that support block-storage-only features (for example, the <SPARSE Report Writer command) cannot be used with aggregate storage databases. MDX queries fully support aggregate storage features.

Attribute Calculation Retrievals

Aggregate storage applications support only the Sum member of the Attribute Calculations dimension. If you specify any other member name from the Attribute Calculations dimension, such as Min or Avg, an error is returned.