35 Block Storage Calculation Optimization

You can configure an Essbase block storage cube to optimize calculation performance.

The information in this chapter applies only to block storage cubes, and is not relevant to aggregate storage cubes.

• Design for Calculation Performance

• Monitor and Trace Calculations

• Calculate Selected Tuples

• Simulate Calculations to Estimate Calculation Time

• Estimate Calculation Effects on Cube Size

• Essbase Formula Optimization

• Bottom-Up and Top-Down Calculation

• Hybrid Mode for Fast Analytic Processing

• Essbase Caches and Calc Performance

• Block Locking and Concurrent User Access

• Two-Pass Calculation

• Member Set Functions and Performance

• #MISSING Values

• Identify Additional Calculation Optimization Issues