Outline Differences

Table 192. 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)

  • 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; see Optimizing Database Restructuring