Think of Essbase engines like different types of car engines: one is for heavy lifting, one is for speed, and one is a high-performance hybrid.
1. The Definitions
* BSO (Block Storage): The "Heavy Lifter." Designed for complex math and Calc Scripts.
* ASO (Aggregate Storage): The "Speed Demon." Designed for massive datasets where you only need to add numbers up quickly.
* Hybrid Mode: The "Best of Both Worlds." It is a BSO cube that uses the ASO engine to calculate totals instantly.
2. The "Photo Editor" Example
* BSO is like Photoshop—complex editing (Math), but takes time to process.
* ASO is like your Photo Gallery—instant scrolling through 10,000 photos, but no complex editing.
* Hybrid is the modern iPhone—instant processing and high-quality editing in one.
3. Architecture Benefits
| Feature | BSO | ASO | Hybrid |
| :--- | :--- | :--- | :--- |
| Calculations | Manual "Agg" | Instant | Instant |
| Complex Math | Yes | No | Yes |
| Big Data | Medium | High | High |