Feature Differences in ASO

Some features of Essbase aggregate storage (ASO) cubes differ from block storage or are not available. Only ASO offers date-time dimensions. Writeback is supported only to level-0 members. For time balance reporting, the time dimension must be stored, and shared members must be level-0.

Table 36-6 Feature Differences Between Aggregate and Block Storage

Features	Aggregate Storage	Block Storage
Aliases	Supported	Supported
Incremental data load	Supported	Supported
LROs	Not supported	Supported
Time balance reporting	Support with the following restrictions: Skip Zeros is not supported Time dimension must contain only stored hierarchies Shared members must be at level zero	Supported
Triggers	After-update triggers supported	On-update triggers and after-update triggers supported
Unicode	Supported	Supported
Variance reporting	Not supported	Supported
Date-time dimension type and linked attribute dimensions	Supported	Not supported
User ability to change data (write-back)	Supported with the following restriction: Write back to an aggregate storage database must be to level 0 members.	Supported