Query Differences

Table 196. Query Differences Between Aggregate Storage and Block Storage

Query Functionality

Aggregate Storage

Block Storage

Report Writer

Supported, except for commands related to sparsity and density of data

Fully supported

Spreadsheet Add-in

Supported, with limited ability to change data (write-back)

Fully supported

API

Supported

Supported

Export

Support with the following restrictions:

  • Export of level 0 data only (no upper-level export)

  • No columnar export

Supported

MDX queries

Supported

Supported

Queries on attribute members that are associated with non-level 0 members

Returns values for descendants of the non-level 0 member.

See also Design Considerations for Attribute Queries.

Returns #MISSING for descendants of the non-level 0 member

Queries on attribute members and shared members

A shared member automatically shares the attribute associations of its nonshared member

A shared member does not share the attribute associations of its nonshared member

Query logging

Not supported

Supported

Query performance

Considerations when querying data from a dimension that has multiple hierarchies.

See Query Design Considerations for Aggregate Storage.

Hierarchies not relevant