Run Test SQL Queries

Administrators can enter a SQL statement directly to query the Oracle Analytics server. This feature is useful for testing and debugging.

1. In the Oracle Transactional Business Intelligence Home page, click the My Profile, and then click Administration.
2. Click Issue SQL.
3. Enter the SQL statement. For example:

   SELECT
   	XSA('weblogic'.'SalesTargets')."Columns"."E1 Sales Rep Name" s_1
   FROM XSA('weblogic'.'SalesTargets')

4. Change the Logging Level if required.
5. Select Use Oracle Analytics Presentation Services Cache.
6. Click Issue SQL.