This section introduces Dynamic Query Analyzer.
What is Dynamic Query Analyzer
Dynamic Query Analyzer provides a graphical flow representation of the dynamic query run tree. This feature allows for a better understanding when it comes to important query decisions, rather than looking through text-based log files. Modelers and professional report authors can use this tool to tune and improve the model and reports that they build.
Working with Dynamic Query Analyzer
As a prerequisite, you need to configure Dynamic Query Mode to log the run trees to a file for every query that it handles. After this setting is applied, a new folder is created in the../logs/XQE/ folder for every report that is executed using this query mode. The new folder is labeled according to the <date>_<time>_<reportname> template, shown in Example, and contains the trace files that can be interpreted with Dynamic Query Analyzer.
Query plan trace folder
The tool can open these file types either from the local file system or remotely using the HTTP protocol. In the case of a web server, create a virtual directory pointing to the ../logs/XQE folder, and amend Dynamic Query Analyzer Remote Log Access preferences You can launch the Preferences dialog box by clicking Window →Preferences.
Dynamic Query Analyzer preferences
Note that in case the remote location is secured, you can also specify credentials to use for authenticating to that remote location. Other than the Remote Log Access, you can also specify IBM Cognos version 10 server and authentication information. Supplying this information enables Dynamic Query Analyzer to browse the content manager and run reports from within the tool.
By default, the Content Store view does not display. You can add this view by opening the Show View dialog box:
Show View dialog box
A new view is added to the Dynamic Query Analyzer interface. This view is similar to the view If you entered the server information in the Preferences dialog box correctly, the view displays the packages and reports that are available in the Content Store.
Content Store view
Expanding reports entries that have been run with the Query execution trace enabled will display the trace entries found in logs folder Double-clicking the Runtree entry opens the trace in the same way as when using File →Open log.
Query run tree
Apart from the Tree Graph view, which can be exported by clicking File →Export Graph, there two more views that can be of great interest when analyzing report queues. The first view is the Graph Navigation view, shown on the left side in Figure, which displays the same run tree in another graphical tree that is easily expanded or collapsed.
Graph Navigation and Query views
The second view is the Query view, shown on the right side in Figure, which displays the data source specific query in a conveniently formatted syntax.
IBM Cognos Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|IBM DB2 Interview Questions||Data Warehousing Interview Questions|
|SQL Interview Questions||IBM Cloud Computing Infrastructure Architect V1 Interview Questions|
|Framework7 Interview Questions||IBM BPM Interview Questions|
|IBM Cognos TM1 Interview Questions||Cognos ReportNet (CRN) Interview Questions|
|Structured Query Report (SQR) Interview Questions||IBM DataPower Interview Questions|
Ibm Cognos Tutorial
Introduction To Ibm Cognos Business Intelligence
Overview Of The Ibm Cognos Business Intelligence Architecture
Business Scenario And Personas Used In This
Create Reporting Packages With Ibm Cognos Framework Manager
Business Intelligence Simplified: An Overview
Individual And Collaborative User Experience
Self Service Interface For Business Users
Actionable Analytics Everywhere
Enterprise Ready Performance And Scalability
Ibm Cognos System Administration
Integrating Ibm Cognos Bi With Ibm Cognos Business Analytics Solutions
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.