What are the two storage options available in Essbase, and what are the differences?
Or what is the difference between BSO & ASO?
Difference BSO- ASO
|
BSO(Block Storage
Option) |
ASO(Aggregate Storage Option) |
|
1.
Write back in BSO. |
No write-back in ASO |
|
2.
Most of the Dimensions are dense
in BSO |
Most
of the dimensions are sparse in ASO |
|
3. Can create more than 1 database per Application
in BSO |
Cannot create more than 1
database per Application in ASO |
|
3. Less no. of Dimensions(between 4 and
8) in BSO |
a large number of dimensions (more than 10) in ASO |
|
4. Much suited for planning applications. |
Not much suited for planning applications. |
|
5. Calc Script/Two-Pass/Attribute Dimension |
no Calc Script/Two-Pass/Attribute Dimension |
|
6. Supports LRO |
Doesn’t Support LRO |
|
7. Convert BSO to ASO |
can’t convert ASO to BSO |
|
8. Currency Conversion
|
No Currency Conversion |
|
9. Supports- Partitions-
Linked, Transparent, Replicated |
support - Linked& Transparent |
|
10. Copy Database |
No- Copy Database |
