Hyperion Interview Question:

Tell me what are the two storage options available in Essbase and what are the differences?

Submitted by: Administrator

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.
Submitted by: Administrator