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:
    	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.