1. Using Oracle Analytics for Oracle Taleo Enterprise Edition
  2. Editing XML Code or SQL Generated for an Analysis

Editing XML Code or SQL Generated for an Analysis

Before you start

This procedure is a step in the process for constructing an analysis. For more information, see "What Is the Process for Constructing Analyses?"

You must have one of the following user type permissions:

  • BI Author Developer

  • BI Tenant Administrator

Home > Oracle Analytics > Catalog

Here's what to do

  1. Edit the analysis.
  2. Click the Analysis editor: Advanced tab.
  3. Use the links that correspond to the analysis name in the Referencing the Results area at the top of the tab to:

    • Display pages that contain links for working with the results of the analysis.

    • Download a file for working with the results of the analysis in Excel. For information, see "Integrating an Analysis with Microsoft Excel's Internet Query Feature".

  4. Use the fields in the Analysis XML area to view and modify the XML code, and click Apply XML.

    If you modify the XML code, then you affect the analysis as it is saved in the Oracle BI Presentation Catalog.

    To apply the settings for the Partial Update and the Bypass Oracle BI Presentation Services Cache boxes, you must also click the Apply SQL button at the bottom of the tab.

  5. Use the read-only box in the SQL Issued area to examine the SQL statement that is sent to the Oracle BI Server when the analysis is executed.
    If you want to create an analysis using the SQL statement from the current analysis as the starting point, then click the New Analysis button. Any hierarchical columns, selection steps, groups, or formatting that are specified in the current analysis are removed.
  6. Depending on the content of the analysis, use the available fields in the Advanced SQL Clauses area to change the subject area, add GROUP BY or HAVING clauses, and specify DISTINCT processing and a prefix.
  7. Click Apply SQL to apply your changes.
    Use care when clicking the Apply SQL button. When you do, Oracle BI EE creates a new analysis based on the SQL statement that you have added or modified. Therefore, you lose all views, formatting, and so on that you had previously created for the analysis. The XML code is also modified for the new analysis.