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.