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. Most people don’t need to perform this task.

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

Setting Caching Options For Your Analysis

You can specify a separate data caching policy for each analysis, which specifies whether cached data can be displayed if it's available.
  1. Open the analysis for editing.
  2. Click the Analysis editor: Advanced tab.
  3. Use the Bypass BI Presentation Services Cache option to specify a caching policy:
    (Default) Clear this option to improve performance by displaying cached data if it’s available. Cached data might be stale if the source data changes rapidly.
    Select this option to always pull fresh data from the data source, even if cached data is available in the system cache. The analysis might take longer to display if it contains a large amount of data.