Part X: Optimizing and Troubleshooting Essbase
This part describes how to optimize and troubleshoot Essbase:
- Monitoring Performance, describes how to use diagnostic tools to analyze and solve problems, check Hyperion Essbase configuration, and analyze Hyperion Essbase performance.
- Improving Essbase Performance, supplies a list of settings and suggested and default values. These settings all affect performance.
- Optimizing Essbase Caches, describes how to size the Hyperion Essbase index cache, data file cache, and data cache.
- Optimizing Database Restructuring, explains the conditions under which Hyperion Essbase must perform database restructuring, and how you can design your outline to minimize this.
- Optimizing Data Loads, describes how to debug problems with data loads and how to optimize your data loads so that Hyperion Essbase can load the data more quickly.
- Optimizing Calculations, describes how to make your calc scripts execute more quickly.
- Optimizing with Intelligent Calculation, describes how to use intelligent calculation to make your calc scripts execute more quickly.
- Optimizing Reports and Other Types of Retrieval, describes ways to generate your reports more quickly, and how to optimize data extraction.
- Error Handling and Troubleshooting for Essbase, provides some suggestions for how to identify problems and correct them.
Note: For information about performance and partitions, see these resources: