2. 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, seeCalculation Order) No association of attribute dimensions with the dimension tagged Accounts Additional restrictions for shared members. See Alternate Hierarchies.	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. See Stored Hierarchies.	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. Note: On dynamic hierarchies, ability to tag any member as label only Note: On conversion from a block storage database, attribute dimension members are tagged as Dynamic Calc. On standard dimension members Dynamic Calc tags are converted and tagged as stored members, which changes the Members Stored value on the Dimensions tab of the Database Properties window in Administration Services.	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 Database Restructuring	Levels of restructure; seeOptimizing Database Restructuring