Feature Differences

Table 197. Feature Differences Between Aggregate and Block Storage

Features

Aggregate Storage

Block Storage

Aliases

Supported

Supported

Currency conversion

Not supported

Supported

Hybrid analysis

Support with the following restriction: queries that contain a relational member and an Essbase member with a formula in the same query are not supported.

For example, if California is a relational member, and the member Profit has a formula, the following report script returns an error:

Jan 
California 
Profit 
!

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)

Transparent partition technique used to enable limited write-back

Fully supported