Execute Test SQL Queries

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

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