Database Reference
In-Depth Information
Table 5.1
Functional
Comparison of Essbase Storage Kernels
BSO
ASO
Functionality Description/Notes
y
y
Supports user queries with oLAP enabled reporting tools
y
y
Supports write-back applications (ASo can only write back to level-0)
y
y
Supports partitioning (ASo has no outline synchronization)
y
y
Supports Development of member Specific Calculations
y
y
Supports Creation of Calculations at all member levels (ASo has some limitations)
y
n
Supports data loads at all levels of the cube
n
y
Allows the developer to determine the order in which a member calculation occurs
(BSo can only control scripted calculations, not member calculations that follow
native rules)
y
y
Supports use of Calc Scripts in batch processing (new ASo feature and there are
significant limitations to functionality)
n
y
Supports greater than 12 dimensions in a design with ease
n
y
Supports dimensions with hundreds of thousands to millions of members
y
n
Supports multiple Databases per Application (while supported, it is not
recommended anymore for BSo)
y
y
Supports use of Attribute Dimensions and Attribute Calculations (ASo: Sum only)
y
n
Supports Association of Attribute Dimensions with the Dimension tagged Accounts
y
y
Supports ragged hierarchies
y
y
Supports Alternate hierarchies
y
y
Supports user Defined Attributes (uDA)
n
y
Supports multiple slices of data that can be merged on request
n
y
Supports replacement of the entire contents of a database, or just an incremental slice
n
y
Supports automatic update of aggregations after a load (ASo: If aggregates exist, they
are updated; BSo all required calc scripts must be run)
y
y
Supports variance reporting
y
y
Supports y-t-D reporting
y
n
Supports all four unary types (+, −, /, *)
n
y
Supports Date/time Dimension type (text metrics)
y
y
Supports report Writer Functionality
y
y
Supports Spreadsheet add-in
y
y
Supports Export Functionality (ASo Level-0 only)
y
y
Supports API
y
y
Supports mDx Queries
y
y
Supports use of alternate Alias tables
y
n
Supports Currency Conversion module
y
n
Supports Data mining module
y
n
Supports Linked reporting objects (Lro)
y
y
Supports hybrid Analysis (ASo some exceptions)
y
y
Supports time Balance Accounting and reporting (ASo some exceptions)
