Opening query log files

When you run a report, query log files are created if the query execution trace option is enabled. Log files are XML files that capture the native MDX queries executed during a report run, along with execution and waiting time metrics for query constructs.

The query log files are contained in a folder named <time-stamp>_<report_name> inside the XQE logs folder. This folder contains one or more profile files named profilingLog-0.xml, profilingLog-1.xml, and so on. If the report execution requires executing subqueries, there is a subfolder named subqueries that contains folders with profile files for each subquery.

After a report is run, you can open the query log files in IBM® Cognos® Dynamic Query Analyzer. You can browse and open log files using any of three methods.