Create or Edit an Analysis in BI Composer

Set up or update an analysis in BI Composer using these steps.

• Select Columns — Select the columns to include in the analysis. You can also:

  • Specify column interactions

  • Specify a column formula

  • Rename a column

  • Hide a column

  See BI Composer wizard -- Create Analysis: Select Columns panel for additional information.

• Select Views — Select the views to include in the analysis, such as a title, table, pivot table, bar graph, and so on. (Not all views available in Oracle Transactional Business Intelligence are supported in BI Composer.) You can also preview the results and display the associated XML code.

• Edit Table — 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 — 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 — Apply sorting and filters to the views. You can also preview the results.

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