Creating Analyses Using BI Composer

In Oracle BI EE, you create an analysis using BI Composer when you select the Analysis option on the New menu in the global header or Create section of the "Home page".

For more information on BI Composer, see "What Is BI Composer?"

To create an analysis using BI Composer:

1. In Oracle BI EE:

   1. In the global header, click New, then Analysis.

   2. Select a subject area. The "BI Composer wizard" is displayed in a new window.

2. In other applications (such as an ADF application):

   1. Click the Subject Areas tab.

   2. Select a subject area.

   3. Click Create. The "BI Composer wizard -- Create Analysis: Select Columns panel" is displayed.

3. Use the Select Columns panel to select the columns to include in the analysis. For each column that you want to add:

   1. Select the column in the Subject Area list.

   2. Click Add to move it to the Selected Columns list.

   If you want to add or remove subject areas from which to select columns, click the Add button in the Subject Area: Subject_Area_Name area to display the "Add/Remove Subject Areas dialog".

   For a column in the Selected Columns list, if you want to:

   • Change the column name or specify a formula for the column, select the column and click Column Properties to display the "Column Properties dialog for BI Composer".

   • Specify what happens when you click either the column heading or a value in the column or hierarchy level, select one of options in the Interaction list for the column.

   • Hide the column in the view, select the Hidden box for the column.

   • Remove the column from the list, select the column and click Remove.

   • Remove all columns from the list, click Remove All.

4. Click the Select Views button in the BI Composer train at the top of the wizard. The "BI Composer wizard -- Create Analysis: Select Views panel" is displayed.

5. Use the Select Views panel to specify the views to include.

6. (optional) If you included a tabular view in the analysis, click the Edit Table button in the BI Composer train. The "BI Composer wizard -- Create Analysis: Edit Table panel" is displayed.

7. (optional) Use the Edit Table panel to edit the layout of the tabular view.

8. (optional) If you included a graph view in the analysis, click the Edit Graph button in the BI Composer train. The "BI Composer wizard -- Create Analysis: Edit Graph panel" is displayed.

9. (optional) Use the Edit Graph panel to edit the properties and layout of the graph.

10. (optional) Click the Sort and Filter button in the BI Composer train. The "BI Composer wizard -- Create Analysis: Sort and Filter panel" is displayed.

11. (optional) Use the Sort and Filter panel to apply sorting and filters to the views.

12. (optional) If you included a tabular view in the analysis, click the Highlight button in the BI Composer train. The "BI Composer wizard -- Create Analysis: Highlight panel" is displayed.

    
    

    Note: The Highlight panel should only be used to format measure columns.

    
    

13. (optional) Use the Highlight panel to apply conditional formatting to the tabular view.

14. Click the Save button in the BI Composer train. The "BI Composer wizard -- Create Analysis: Save panel" is displayed.

15. Use the Save panel to save the analysis with the same name or with a different name by specifying the save criteria and then clicking Submit.