How to see Native SQL in Framework Manager?

Technote (troubleshooting)


Problem(Abstract)

How to see the native SQL or Cognos SQL in Framework Manager?

Resolving the problem

Edit the definition of a query subject. Test for the results. The SQL will be generated in the "Results Information" tab.

If the "Results Information" tab is blank, you'll need to edit the "Level of information shown in the Results Information" by using the slider in Options.

Steps:1. edit the definition of a query subject

2. click "test" to return data in the test results window

3. click on "Results Information" to view the Cognos SQL and the native SQL.

4. if the window is blank, click on Options in the Query Subject window.

5. move the slider for "Level of information shown in Results Information" to the right for more detail.

Historical Number

1021539

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos ReportNet
ReportNet

Software version:

Cognos ReportNet 1.1MR2, Cognos ReportNet 1.1MR3

Operating system(s):

Win, Windows

Reference #:

1345724

Modified date:

2008-02-19

Translate my page

Machine Translation

Content navigation