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
Here's what to do
- Edit the analysis.
- Click the Analysis editor: Advanced tab.
- 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".
- 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.
- 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.
- 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.
- 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.