Query Differences with ASO

Essbase aggregate storage (ASO) queries differ from block storage in some respsects. Writeback and export are supported only for level-0 members. Queries pertaining to density and sparsity are not applicable.

Table 36-5 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
Smart View	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 Attribute Queries on ASO Cubes in Design Considerations for Aggregate Storage Outlines.	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 prototype member	A shared member does not share the attribute associations of its prototype member
Query logging	Supported	Supported
Query performance	Considerations when querying data from a dimension that has multiple hierarchies. See also Attribute Queries on ASO Cubes in Design Considerations for Aggregate Storage Outlines.	Hierarchies not relevant