Outline Differences for ASO

Essbase aggregate storage (ASO) outlines have no dense or sparse dimensions, no two-pass calculation, no Dynamic Time Series, and no Dynamic Calc and Store. There are some restrictions on shared and label only members.

Table 36-1 Outline Differences Between Aggregate Storage and Block Storage

Outline Functionality	Aggregate Storage	Block Storage
Dense or sparse dimension designation	Not relevant	Relevant
Multiple hierarchies enabled, dynamic hierarchy, or stored hierarchy designation	Relevant	Irrelevant
Accounts dimensions and members on dynamic hierarchies	Support with the following exceptions: No two-pass calculation (however, for information on specifying the calculation order, see Calculation Order and Solve Order in ASO Cubes) No association of attribute dimensions with the compression dimension (aggregate storage only) Additional restrictions for shared members. Review Alternate Hierarchy Restrictions for Shared Members in Hierarchies in ASO Cubes.	Full support
Members on stored hierarchies	Support with the following exceptions: Support for the ~ (no consolidation) operator (underneath label-only members only) and the + (addition) operator Cannot have formulas Restrictions on label only members (See Member storage types.) No Dynamic Time Series members Stored hierarchy dimensions cannot have shared members. Stored hierarchies within a multiple hierarchies dimension can have shared members. Review Stored Hierarchies in Hierarchies in ASO Cubes.	Full support
Member storage types	Support with the following exceptions: Dynamic Calc and Store not relevant On stored hierarchies, two limitations if a member is label only: All dimension members at the same level as the member must be label only The parents of the member must be label only. On dynamic hierarchies, ability to tag any member as label only	Support for all member storage types in all types of dimensions except attribute dimensions
Ragged hierarchies and hierarchies with more than 10 levels	Support, with possible performance impact	Support
Outline validation	When database is started When outline is saved When block storage outline is converted to aggregate storage outline When user requests	When outline is saved When user requests
Outline paging	Support	No support
Database restructure	Levels of restructure; see Aggregate Storage Cube Restructuring	Levels of restructure; see Optimizing Database Restructuring