Data Load Functionality
|
Aggregate Storage
|
Block Storage
|
Cells
loaded through data loads
|
Only level 0 cells whose values do not depend on formulas in the
outline are loaded
|
Cells at all levels can be loaded(except Dynamic Calc members)
|
Update
of database values
|
At the end of a data load, if an aggregation exists, the values in
the aggregation are recalculated
|
No automatic update of values. To update data values, you must
execute all necessary calculations scripts
|
Data
load buffers
|
The loading of multiple data sources into aggregation storage
database is managed through temporary data buffers
|
Not Supported
|
Atomic
replacement of the contents of a database
|
When loading data into an aggregate storage database, you can replace
the contents of the database or the contents of all incremental data slices
in the database
|
Not Supported
|
Data
Slices
|
Aggregation storage database can contain multiple slices of data.
Data slices can be merged
|
Not Supported
|
Dimension
build for shared members
|
Full support for parent-child build method. Duplicate generation
(DUPGEN) build method limited to building alternate hierarchies up to
generation 2(DUPGEN2).
|
Support for all build methods
|
Loading
data mapped to dates
|
In a date-time dimension, you can load data into level 0 members
using supported date-format strings instead of member names
|
Date-time dimension type is not supported
|
Avinash Hyperion OBIEE Business Intelligence
Sunday 3 August 2014
Data Load Differences between ASO & BSO
Subscribe to:
Posts (Atom)