Classical question at tests: I have 4 dimensions: Markets: Sparse, 10 stored members, 10 total members Products: Sparse, 5 stored members, 7 total members Accounts: Dense , 10 stored members, 11 total members Time : Dense, 5 stored, 12 total
What is the size of that BSO? How do I calculate it?
The Essbase Database Administrators Guide has a worksheet you can use to calculate the size of a cube.
For your example, you have 2 dense dimensions:
Total number of cells in a block: 50.
8 bytes per cell, so 50 * 8 = 400 bytes expanded block size.
You have 2 sparse dimensions:
So you have 10 * 5 = 50 possible data blocks, for a total (assuming the database is entirely filled) of 20,000 bytes.
