Hyperion Question:
Tell me what are the two storage options available in Essbase and what are the differences?
Answer:
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.
* 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.
| Previous Question | Next Question |
| What is VMS system? | Tell me can we have one ASO database and one BSO database in one single application? |