What Is the Analysis Editor?

The "Analysis editor" lets you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can include the views that you create in an analysis for display in dashboards.

The Analysis editor contains the following tabs:

Criteria tab — Lets you specify the criteria for an analysis, including columns, and filters. You can specify the order in which the results should be returned, formatting (such as headings, number of decimal places, styles such as fonts and colors, and conditional formatting), and column formulas (such as adding a Rank or Percentile function). Additionally, you can change the sort order of the subject area and subject area folders (see "Changing the Sort Order of Subject Areas and Subject Area Folders" for additional information).
Results tab — Lets you create different views of the analysis results such as graphs, tickers, and pivot tables. You can also add or modify selection steps.
Prompts tab — Lets you create prompts that allow users to select values to filter an analysis or analyses on a dashboard. Prompts allow users to select values that dynamically filter all views within the analysis or analyses. You can also create prompts for use with selection steps, both for member selection steps and qualifying condition steps.
Advanced tab — Lets you edit XML code and examine the logical SQL statement that was generated for an analysis. You can use the existing SQL statement as the basis for creating a new analysis.

The tabs of the Analysis editor are organized into various panes and areas. As you work, you can manage these panes to suit your needs. See "Managing Panes in the Analysis Editor Tabs."

You access the Analysis editor when you create (or edit) an analysis. See "Creating New Analyses."

Note:

If you are using Oracle BI EE in accessibility mode, then, when you create (or edit) an analysis, the Analysis editor is replaced by the "BI Composer wizard." For more information on BI Composer, see Chapter 14, "Using BI Composer to Work with Analyses." For more information on accessibility mode, see Appendix C, "Accessibility Features."

Managing Panes in the Analysis Editor Tabs

Each of the tabs in the Analysis editor consists of several panes. For example, the Results tab consists of the "Subject Areas pane," the "Catalog pane," the "Views pane," the "Compound Layout," and the "Selection Steps pane."

As you work, you can manage these panes to give yourself the most efficient work area for the task that you are performing. For example, if you add multiple views to the compound layout on the Results tab, then you might want to hide the other panes in the Results tab to maximize the area in which to see the views that you are adding. You can:

Show or hide the panes that are displayed on the left side of the Analysis editor by clicking the sideways triangle button that is displayed between the left and right sides.
Expand or collapse an individual pane by clicking the plus or minus button in the title bar of the pane.
Resize an expanded pane by dragging its splitter. For example, you can drag the splitter on top of the Catalog pane up to increase the height of the pane.
Show or hide a pane by clicking its show/hide toolbar button, if one is available for the pane on the toolbar. For example, you can show or hide the Filters pane in the Criteria tab by clicking the Show/Hide Filters pane button on the toolbar.