Finalize the cube type
Using what you've learned about calculations, revisit the initial choice (ASO or BSO) that you made when you started planning your Essbase application.
| If your application primarily needs: | Consider: |
|
Aggregation across large dimensional models |
ASO |
|
Reporting and multidimensional analysis of detailed data |
ASO |
|
Hierarchical aggregation and member formulas |
ASO or BSO |
|
Business formulas without a larger procedural calculation process |
ASO or BSO |
|
Allocations |
ASO or BSO |
|
Data entry combined with substantial business calculations |
BSO |
|
Forecasting that is part of a repeatable calculation process |
BSO |
|
Calculations that occur in several steps or in a required sequence |
BSO |
|
Calculation scripts that implement recurring business processes |
BSO |
Your application might contain requirements from both sides of the table. Focus on the requirements that are most important to the application's purpose rather than choosing a cube type based on a single feature.
After you make your choice, continue with the calculation approach that applies to your cube:
-
For an ASO cube, learn how aggregation, hierarchies, member formulas, solve order, and supported ASO calculations work together. Refer to: Design Flow for Aggregate Storage Applications
-
For a BSO cube, learn how outline calculations, member formulas, and calculation scripts implement your business logic. Refer to: About Block Storage Calculation
Parent topic: Apply Business Logic with Calculations