Correct Performance Issues

To improve performance, try one or more of the following techniques:
  • Switch off automatic retrieval of data until you are ready to update the information in your report.
  • Switch off automatic retrieval of data while you are drilling down, slicing and dicing, formatting, and so on. When the report looks the way you want, from the Explore menu, click Get Data, Now to retrieve data.
  • Reduce the number of undo actions that IBM® Cognos® PowerPlay® stores. From the File menu, click Preferences. On the Options tab reduce the value of the Maximum number of Undo actions option. More memory is then available.
  • Switch off suppression of zeros. From the File menu, click Preferences. On the Suppress tab, set the suppression options.
  • Limit the number of categories in a Reporter report by removing unnecessary categories.
  • Delete hidden categories.
  • Divide a large cube into smaller, more manageable cubes. The administrator can do this for you, or ask the administrator about changing the ReadCacheSize setting. Increasing the value for ReadCacheSize increases PowerPlay's performance.
  • Summarize the details and sort the remaining categories to your specifications. The administrator can do this for you. For example, if the cube contains more levels of detail than you need, and the categories are not sorted logically, you may not be able to analyze your business quickly. The administrator can change the model so that you can more quickly find the information you need.
  • Limit the number of rank calculations. Use manual ranks instead of automatic ranks.
  • Tune Windows performance in general. See your Microsoft Windows documentation for more information.