This section provides some tips for troubleshooting your models.
Examine the SQL
When testing query objects in IBM Cognos Framework Manager, you can view the SQL that is generated for the query on the Query Information tab. Viewing this information can be a useful way to verify expected results and can be a valuable troubleshooting technique to help you debug a model.
In particular, you can verify query path and join conditions and determine if elements of the query are being processed locally by comparing the Cognos and Native SQL. Items that appear in the Cognos SQL but are not replicated in the Native SQL indicate that additional processing of the data is required on the IBM Cognos servers. This issue might be due to unsupported functions in the vendor database.
You can also select the Response sub-tab in the Query Information tab to view the request and response sequence to and from the data source. Any warning or error messages generated are recorded here.
To test a query and examine the generated SQL:
Query Information tab
You can find objects easily that depend on other objects or show the dependencies of a child object. To determine object dependencies:
Search the model
When working with a large project, it can be difficult to locate the objects that you need to complete a task. Use the Search tab to find objects quickly by applying different search criteria, such as the location, the class, a condition, or a property.
If the Tools pane is not visible, from the View menu, click Tools. You can drag the Tools pane to the bottom of the IBM Cognos Framework Manager window and resize it to have a better view of the search results.
To search the model:
You can use uppercase, lowercase, or mixed case strings. The search is not case sensitive. Valid wildcard characters are an asterisk (*) and a question mark (?).
The Condition box determines how the Search string value is matched with text in the model. It contains a list of possible search conditions. If you want to search using wildcard characters, use the equals condition.
The (All Properties) property searches all properties. The Object Name property restricts the search to the name of each object. The Text Properties property searches the set of properties that contain text strings, such as Description or Screen Tip, but not the object name.
The results are listed at the bottom of the Search tab. After you do one search, the Subset check box becomes available. If you select Subset, the next search operates on the existing search results. The Subset option iscleared after each search.
Now that you have seen the basics of developing a simple IBM Cognos Framework Manager model, it is a good idea to augment this knowledge with formal training to ensure the success of your IBM Cognos BI project.
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.