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.