Steps for Creating or Editing an Analysis in BI Composer

The steps for creating or editing an analysis in BI Composer are as follows:

  • Select Columns — In this step you select the columns that are to be included in the analysis. You can also:
    • Specify column interactions

    • Specify a column formula

    • Rename a column

    • Hide a column

  • Select Views — In this step you select the views that are to be included in the analysis, such as a title, table, pivot table, bar graph, and so on. (Note that not all views available in Oracle BI Enterprise Edition are supported in BI Composer.) You can also preview the results.

  • Edit Table — In this step you edit the layout of the tabular view (if you have included a tabular view). For example, you can create prompts, use a column to section the analysis, and exclude certain columns from the tabular view. You can also preview the results.

  • Edit Graph — In this step you edit the properties and layout of the graph (if you have included a graph view). For example, you can create prompts, use a column to section the analysis, and exclude certain columns from the graph. You can also preview the results.

  • Sort and Filter — In this step you apply sorting and filters to the views. You can also preview the results.

  • Highlight — In this step you apply conditional formatting to the tabular view (if you have included a tabular view). You can also preview the results.

  • Save — In this step you save the analysis with the same name or with a different name. You can also:
    • Create new folders in which to save the analyses

    • Rename folders and analyses

    • Delete folders and analyses

    • Expand and collapse folders