Query Design Considerations for Aggregate Storage

When querying data from a dimension that has multiple hierarchies, query performance may improve if you query the data in the following way:

  1. Select the hierarchy that you want to query.

  2. Navigate to find the detailed data (for example, by zooming in on the hierarchy in Oracle Hyperion Essbase Spreadsheet Toolkit).

Including dynamic hierarchy members and stored hierarchy members in the same query may require a large internal memory cache, which decreases query performance.