Run Test SQL Queries

Administrators can enter a SQL statement directly to underlying data sources. This feature is useful for testing and debugging.

1. In the Oracle Analytics Home page, click the Navigator, and then click Console.
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.