Essbase - ASO/BSO Storage
Storage type
Essbase support two storage type :
- and aggregate storage as a persistence mechanism
for multidimensional databases.
Aggregate storage databases enable dramatic improvements in both :
- database aggregation time
- and dimensional scalability.
The aggregate storage kernel is an alternative to the block storage kernel. Aggregate storage databases typically address read-only, “rack and stack” applications that have large dimensionality.
| Business Application | Properties | Storage |
|---|---|---|
| Customer Analysis | Many dimensions, million of customer | Aggregate |
| Sales Forecasting | Top-down planning and allocations | Block |
| Procurement Analysis | Many products across many customers | Aggregate |
| Profitability Analysis | Cost Allocations across products and customers | Block |
| Logistics Analysis | Near real-time information on product shipments | Aggregate |
| Financial consolidations | Currency conversion, inter-company eliminations | Block |
Articles Related
What determine how data is stored in the database ?
- The structure defined in the outline : Essbase - Designing an Outline to Optimize Query or Calculations Performance
- The dense and sparse property of the dimension : Essbase - Dense and Sparse Selection Effect on the data storage (performance)
ASO / BSO Storage structure
Block storage outline (BSO) uses two types of internal structures to store and access data:
- and index
The blocks exist and you are just pulling calculated values out of them.
Aggregate storage (ASO) does not have this block concept. In ASO nothing bet the level 0 blocks exist.
ASO uses MDX and BSO calc scripts.
ASO has its own export data routine which exports only level 0, whereas DATAEXPORT for BSO allows exporting data at any level.
Can I move my Cube from BSO to ASO
If the BSO calculation is just aggregating the cube then it should be okay. If the calculation script is executing any type of logic, then you will have to deteremine if that functionality can be replicated using MDX member formulas. If it can't, then the application might not be a good candidate for ASO. Not all BSO apps can be converted to ASO. It depends on the functional requirements.
