268 IBM Cognos Dynamic Cubes
10.3 Reviewing Cognos reports with Dynamic Query Analyzer
The Content Store view can be used to browse through content held within a Cognos
Enterprise system. A selected content object can be run to produce execution and planning
traces for review.
A report query execution trace is stored on the IBM Cognos 10.2 Business Intelligence Server
and is found relative to the Cognos installation directory under the logs/XQE folders.
A report query execution trace is recorded with the following folder structure and file profile:
FolderName: <Run Date>_<Timestamp>_<ObjectName>
In Dynamic Query Analyzer, a report query execution trace is shown in the Content Store
view as children of the report object. Query Execution traces can also be browsed in the
Report Logs view.
Use the following procedure to generate a report:
1. Open Dynamic Query Analyzer.
2. Select Window Preferences Content Store Open the latest log to have
Dynamic Query Analyzer automatically open the most recent query execution log
associated with a report run. The default preference is to prompt to open the most recent
log that follows a report run.
3. Verify the Content Store view is visible. Select File Open IBM Cognos Portal.
4. In the Content Store view, expand folders Dynamic Cube Reports to browse the
available Cognos content to identify the target report BranchProfileByYear.
5. Right-click the context menu on the BranchProfitByYear report, and select Run Report.
6. The report output is displayed in a new Browser view tab.
Note: In the Cognos Cube Designer, you may also verify the element and member
structure for a dimension hierarchy. Expand the Members folder under any dimension
hierarchy definition to list members in their hierarchical order.
Note: You can also make the Content Store view visible from the Show View dialog:
a. Select Window -> Show View.
b. Select Content Store from the Navigation folder in the Show View dialog.
Chapter 10. Troubleshooting 269
Figure 10-11 shows the Dynamic Query Analyzer Report View.
Figure 10-11 Dynamic Query Analyzer Report View
7. The report execution tree that is associated with the report opens in a new graph view.
Note: A report query execution trace can also be loaded from the Report Logs view.
Display the Report Logs view (if it is not visible) and load a report query execution trace:
a. Select Window Show View.
b. Select Report Logs from the Navigation folder in Show View dialog.
c. Click OK to close the dialog.
d. Browse the Report Logs view by report name and timestamp to identify the
report query execution trace folder.
e. Expand the report trace folder and double-click Profile 0, which is the