Advanced Techniques: Examining the Logical SQL Statements for Analyses

You can examine the logical SQL to see the XML code and logical SQL statement that is generated for an analysis. You can optionally create an analysis based on that SQL statement using the Advanced tab of the Analysis editor.

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.

To examine the SQL statement that is generated for an analysis:

  1. Open the analysis for editing.

  2. Click the Analysis editor: Advanced tab.

  3. Use the read-only box in the SQL Issued area to examine and copy the SQL statement that is used for executing the analysis.

  4. Click New Analysis to create an analysis based on the SQL code.