Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Analysis editor: Advanced tab

Use this tab of the "Analysis editor" to examine or edit the XML code and logical SQL statement that is generated for an analysis. This tab is for use only by advanced users and developers who have the appropriate privileges. See "Examining the Logical SQL Statements for Analyses" for additional important information on working with this tab.

For more information, see:


Referencing the Results

Use this area at the top of the tab to access a link that is identified with the name of the analysis to display individual pages that contain links for refreshing, modifying, and viewing the results of the analysis. You can bookmark these pages for use as links from other web pages and portals.

This link executes for the analysis as it is currently saved. If you update the analysis later, then the link is also changed for those updates. The link is not visible if you have not yet saved an analysis.

Analysis XML

Use this area to view and modify the XML code for an analysis.


Analyses are stored in the Oracle BI Presentation Catalog in XML format. If you change the XML code, then you change the analysis in the catalog.

Use the following components in this area:

SQL Issued

Use this read-only box to view the SQL statement that is sent to the Oracle BI Server when the analysis is executed.

New Analysis

Click this button to display the "Analysis Simple SQL Statement dialog," in which you create an analysis using the SQL statement from the current analysis as the starting point. Any hierarchical columns, selection steps, groups, or formatting that are specified in the current analysis are removed before the dialog is displayed. You can edit the SQL statement in this dialog.

Advanced SQL Clauses

Use this area to modify the SQL statement for an analysis. You can include additional SQL clauses and change the subject area or the FROM clause for certain analyses. All but one of these features are disabled for analyses that contain hierarchical columns, member selections, or groups. Only the ability to specify a prefix is enabled.

Use the following components in this area:

Apply SQL

Click this button to apply the:


Use care when clicking this button. When you do, Oracle BI EE essentially 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.

Query Performance

Use this area to set the following components:


Use this button to apply the settings for the options in the Query Performance area.