Essbase Storage Options

1. Aggregate Storage Option ASO
* Used for more than 10 dimensions
* The majority of the dimensions will be distributed.
* It is impossible to write back in ASO. In the next versions we should be able to write it back.

2. Block Storage Option BSO
* Less Dimension and more dense dimensions
* Write back quality is present, good for application planning. The commercial programs are usually dense, the analytical cubes-sparse.

In ASO we have only one DB per app whereas in BSO we can have more than 1 DB in single app.

in ASO we are useed in the MDX formulas