1. Using Oracle Business Intelligence for Oracle Talent Acquisition Cloud

16BI Composer

BI Composer

    BI Composer

      BI Composer

      BI Composer is a simple-to-use wizard that allows you to quickly and easily create, edit, or view analyses without the complexities of the "Analysis editor".

      The main components of the "BI Composer" are as follows:

      • At the top of the wizard is the BI Composer train, which contains buttons for each step in the wizard. For more information, see "Steps for Creating or Editing an Analysis in BI Composer".

      • The panel area, where the components for each step are displayed.

      • To the far right are the Back, Next, Finish, and Cancel buttons.

      BI Composer Modes

      There are two modes in which BI Composer is available in an application (such as Oracle BI) — regular mode and accessibility mode. Accessibility mode has the same functionality as regular mode but is optimized for use with screen reader applications such as JAWS. It makes it easier for users with visual impairments to create, edit, and view analyses.

      BI Composer Availability

      When users work with analyses in Oracle BI, BI Composer may be displayed in place of the "Analysis editor", depending on the preferences users make as follows:

      • BI Composer is displayed in regular mode in place of the Analysis editor, when users have specified that they want to use the BI Composer wizard as the analysis editor and have turned off accessibility mode in Oracle BI.

      • BI Composer is displayed in accessibility mode in place of the Analysis editor, when users have turned on accessibility mode in Oracle BI EE.

      Users specify that they want to use the BI Composer wizard as the analysis editor by selecting the Wizard (limited functionality) option for the Analysis Editor component in the "My Account dialog: Preferences tab".

        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

          Creating an Analysis Using BI Composer

          You must have one of the following user type permissions:

          • BI Author Limited

          • BI Author Developer

          • BI Tenant Administrator

          .Home > Oracle Business Intelligence > Catalog

          1. In Oracle BI:

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

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

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

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

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

          5. (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.

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

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

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

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

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

          11. (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.

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

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

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

            Editing an Analysis Using BI Compser

            You must have one of the following user type permissions:

            • BI Author Limited

            • BI Author Developer

            • BI Tenant Administrator

            .Home > Oracle Business Intelligence > Catalog

            1. Edit the analysis in one of the following ways:

              • From the Catalog or Home page in Oracle BI, navigate to the analysis and click Edit. The BI Composer wizard is displayed.
              • From the BI Composer wizard, click the Catalog tab, select the analysis, and click Edit.

            2. Make the changes to the analysis by navigating the steps of the wizard using the buttons in the BI Composer train at the top of the wizard.

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

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

              Viewing an Analysis in BI Composer

              You must have one of the following user type permissions:

              • BI Consumer

              • BI Author Limited

              • BI Author Developer

              • BI Tenant Administrator

              Home > Oracle Business Intelligence > Catalog

              1. Click the Catalog tab.

              2. Select the analysis.

              3. Click View. The analysis is displayed for viewing to the right of the Catalog tab.