Sunday, 3 August 2014

Data Load Differences between ASO & BSO




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