
28 IBM Cognos Dynamic Cubes
The result set and expression caches, in turn, reduce the amount of processing that occurs
within the MDX engine within the DQM server, helping to reduce spikes in resource usage.
Cognos Dynamic Cubes also makes use of available processing cores to do costly operations
in parallel, such as loading hierarchy tables, or processing query result sets.
Cognos Dynamic Cubes uses five caches, each with a separate purpose. The following
sections describe these cache types.
2.3.1 Result set cache
The result set cache exists at a layer directly above the MDX engine with the DQM server.
The result set of each MDX query executed ...