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 35-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:
|
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 |