Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Working with Oracle BI Views in Oracle BI Answers >

Showing the Logical SQL for a Request Using Oracle BI Logical SQL View

Use the logical SQL view to show the SQL generated for the request. This view is useful for trainers and administrators, and is usually not included in results for typical users.

To add or modify an Oracle BI logical SQL view

1. In Oracle BI Answers, create or modify the request with which you want to work, and then perform one of the following actions:
   • To add a new logical SQL view, click the Results tab and choose Other Views > Logical SQL from the views drop-down list.
   • To edit an existing logical SQL view, click the Results tab, choose Compound Layout from the views drop-down list, and then click the Edit View button for the logical SQL view.

     The workspace shows the logical SQL view.

2. To issue SQL directly to the Oracle BI Server, click the Issue SQL button.

   The Issue SQL Directly dialog box appears, with instructions to help you issue SQL.

3. When you are done, you can save the request with the logical SQL view.

Related Topics

Overview of Oracle BI Answers

Performing Common Tasks When Working with Oracle BI Views