Difference BSO, ASO

                                              

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