1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Report Data
  3. Create Analyses
  4. Advanced Techniques: Examine the Logical SQL Statements for Analyses

Advanced Techniques: Examine the Logical SQL Statements for Analyses

You can examine the logical SQL code to see the XML code and logical SQL statement that's generated for an analysis. You can optionally create an analysis based on that SQL statement using the Advanced tab of the analysis editor or using the Create Analysis from Simple Logical SQL option. Most people don’t need to perform this task.

When you create an analysis using this method, the list of subject areas isn't displayed in the left-hand pane. Instead you see the message Invalid Subject Area displayed. The removal of the list of subject areas ensures that the changes made to the logical SQL code are honored.

Before using the Advanced tab, keep in mind that this tab is only for advanced users and developers who have the appropriate responsibilities to access the Advanced tab. You must understand advanced SQL statements and have expertise working with the metadata for analyses. You must also understand the content and structure of the underlying data sources.

  1. Open the analysis for editing.
  2. Click the Advanced tab of the analysis editor.
  3. Use the read-only box in the SQL Issued area to examine and copy the SQL statement that's used for executing the analysis.
  4. Click New Analysis to create an analysis based on the SQL code.