
Chapter 10. Troubleshooting 263
10.2 Visualizing dynamic cube startup
Chapter 2, “IBM Cognos Dynamic Cubes architecture” on page 9 outlines the architecture of
dynamic cubes and the caching strategy available to optimize performance, when basing
reports on Cognos Dynamic Cubes.
With Dynamic Query Analyzer, you can review the startup sequence and queries that are
issued to the source database to retrieve dimension members and their associated attributes.
For each cube start, query execution logs are recorded in the <CognosInstall>/Logs/XQE
folder in a designated cube folder with a Cube_<CubeName> format.
A separate trace is produced for each dimension ...