Administration: Issue SQL page

Use this page to enter a SQL statement to send directly to the Oracle BI Server. This feature is intended for testing the server only. Results are not formatted, and it is not possible to save the SQL statement that you issue here as an analysis. Not all SQL functions and procedures for Oracle BI Server are supported for use through the Issue SQL page, such as the NQSSetSessionVariables() procedure.

For more information, see Appendix D, "Logical SQL Reference."

Components

SQL

Use this field to enter a SQL statement to send directly to the Oracle BI Server.

Issue SQL

Click this button to send the SQL statement to the Oracle BI Server.

Logging Level

Use this box to select the Oracle BI Server logging level, from 0 through 7. Each user receives a default logging level during user creation in the BI Server Administration tool. Select Default in this box to specify the use of your default level.

For information on logging levels, see "Viewing and Configuring Diagnostic Log Files" System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Use Oracle BI Presentation Services Cache

Use this box to specify whether to use the Oracle BI Presentation Services Cache. Deselect this box to specify that you do not want the query to use the Presentation Services cache. In general, you should avoid deselecting this box as disabling the cache has potential performance degradation issues.