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

  • 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. For more information on accessibility mode, see Appendix C, Accessibility Mode.