Model troubleshooting tips - IBM Cognos

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:

  1. Right-click a query subject or multiple selected query items, and click Test.
  2. Test the results, and then click the Query Information tab to view the SQL generated for the query.
  3. Query Information tab
    Query Information tab

  4. To view the request, the response, and any warning messages that were generated, click the Response tab,
  5. Response tab
    Response tab

Object dependencies

You can find objects easily that depend on other objects or show the dependencies of a child object. To determine object dependencies:

  1. In the Project Viewer, click an object.
  2. From the Tools menu, click Show Object Dependencies. The objects that depend on the selected object display under Dependent objects.
  3. To show the object identifier for the dependent objects, select Show Object ID.
  4. If the selected object has children and you want to see the dependencies for a child object, click the plus sign (+) beside the object that contains the child object.
  5. Click a child object under the parent object. The objects that depend on the child object display under Dependent objects. You can also show object dependencies using the following methods:
    • Use the Project Viewer by right-clicking an object and selecting Show Object Dependencies.
    • Use the Context Explorer window by right-clicking an object and selecting Show Object Dependencies.
    • Use the Analyze Publish Impact window by clicking the Show Dependencies icon underActions in the row that contains the object.

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:

  1. In the Tools pane, click the Search tab.
  2. In the Search String field, type the text that you want to find.
  3. 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 (?).

  4. Click the double down arrow button to show the search criteria boxes.
  5. In the “Condition” list, select a condition to apply to the search string.
  6. 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.

  7. In the “Search in” list, select the part of the model hierarchy that you want to search.
  8. In the “Class” list, select the single class of objects that you want to search.
  9. In the “Property” list, select the type of property that you want to search.
  10. 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.

  11. Click Search.
  12. 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.

  13. To see an object in the Project Viewer, click an object in the Search tab.
  14. To see an object in the diagram, right-click an object in the Search tab, and click Locate in Diagram.

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.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

IBM Cognos Topics