About Aggregate Storage Databases

This topic explains how the elements discussed in the Technical Reference apply to aggregate storage databases.

Consider using the aggregate storage model if the following is true for your database:

For more information about aggregate storage, see the Database Administrator's Guide.

MDX

The MDX language is used for querying on block storage and aggregate storage databases. Additionally, MDX numeric-value expressions can be used for developing formulas on aggregate storage outlines. For more information, see MDX Outline Formulas.

Calculation Commands

Calculation commands are not supported in aggregate storage databases, because calculation scripts are not relevant to aggregate storage.

Calculation Functions

Calculation functions are not supported in aggregate storage databases. Instead, MDX formulas can be written using MDX numeric-value expressions. Only the Accounts dimension can have formulas in aggregate storage databases.

Report Writer Commands

All of the Report Writer commands (except <SPARSE) are supported for aggregate storage databases.

MaxL Statements

Some MaxL grammar is applicable to aggregate storage mode, and some MaxL grammar is not relevant. To learn which statements are supported in aggregate storage application and database operations, see MaxL Statements (Aggregate Storage).

ESSBASE.CFG Configuration Settings

Some ESSBASE.CFG configuration settings are applicable to aggregate storage mode, and some are not. To learn which settings are supported in aggregate storage mode, see the Aggregate Storage List of ESSBASE.CFG settings.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com