Create and View Business Analytics Dashboards

Use the Business Data Query to plot and view charts and graphs for application metrics and create Business Analytics Dashboards. You can create charts that display business indicator values (metrics specific to a process) and system indicator values (metrics automatically captured).

When designing a process, developers create business indicators for data objects whose metrics they want to capture and display as X axis, Y axis, and filter values. You select the business or system indicators to plot them in charts and graphs. You must be assigned the Process Owner role, the Administrator role, or the Analytics Viewer role to create and view business analytics dashboards. See Assign and Manage Roles.

To create and view business analytics charts and graphs:

1. In the Oracle Integration navigation pane, click My Tasks, click Workspace, and then click Dashboards.
2. Click the Business Analytics tab.
   If you’re creating a query for the first time, click Get Started.
3. In the Reports pane, click New Query .
4. Enter a name in the Untitled field.
   You can also add a description for the new query in the Add description field.
5. In the Data Source Type field, select a source for the chart or graph.
   Typically, this value is left as Process, the default value.
6. In the Application field, select the application to report on.
   You can select All Applications to report across multiple active applications, using system indicators only.
7. In the X Axis options, scroll the Series and Group fields to see available indicators, and select dimension indicators to plot for the chart’s X axis.

   Business indicators are listed first, followed by standard system indicators. Want to learn more about dimension indicators? See Add Dimension Business Indicators. You must specify both a series and a group indicator for the X axis.

   Note:

   If you select the Date data type indicator for the X axis, then you can use the Time Grouping option to specify the time frame for the business analytics dashboards of the application. For example, in case of a Travel Request Application, if you select Year, you can view the number of Travel Requests by the year.
8. In the Y Axis fields, scroll the Measure field to see available indicators, and select a measure indicator and standard function to plot for the Y axis.
   See Add Measure Business Indicators.
9. Optionally, add one or more filters. Click Add Filter. From the fields that display, click the left one to see available indicators, and select an indicator by which to filter. For available system indicators, see Select System Indicators.
   Want to learn more about attributes? See Add Attribute Business Indicators.
10. Click Display Report.

    The chart is plotted and displayed on the right side of the page.

    
    Description of the illustration edit-query.png

11. Click Save to save the business analytics dashboard that you just created.
    After you save the query, you can select and view it on the Reports pane.

    Note:

    You can use the Collapse button to hide the Reports pane when not in use.

    
    Description of the illustration business-analytics-dashboards.png

12. Optionally, change the chart or graph’s display.
    1. Use the Data for last drop down list to select the duration of the activity. By default, the data for last 1 month is selected.
    2. Use the icons in the top and bottom to change the chart’s type and orientation and stack.
13. You can Delete or Copy the Business Analytics dashboard or Reset the fields for X axis and Y Axis and create a new graph.
14. Optionally, export the data to a file, click Download CSV, and open or save the export.csv file.

Select System Indicators

You can select the system indicators when you add filters to create business analytics charts and graphs.

The following are the valid filter values for some of the system indicator columns:

1. Is Recoverable

   • Y: Represents Yes

   • N: Represents No

2. All other system indicator colums starting with "Is ..."

   • 0: Represents false

   • 1: Represents true

3. Due Status

   • DUE SOON

   • MISSED DUE

   • ON TRACK

   • OVERDUE

4. Process Activation Status

   • -1: refers to un-activated status

   • 0: refers to retired status

   • 1: refers to activated status

5. Process Instance Status

   • ABORTED

   • ACTIVE

   • COMPLETED

   • FAULTED

   • SUSPENDED

6. Activity Instance Status

   • ABORTED

   • ACTIVE

   • COMPLETED

   • FAULTED

   • MOVED

   • SUSPENDED

7. Assignment state

   • ACQUIRED

   • ASSIGNED

   • COMPLETED

   • ERRORED

   • EXPIRED

   • DELETED

   • WITHDRAWN

   • SUSPENDED

8. Task State

   • ALERTED

   • ASSIGNED

   • COMPLETED

   • ERRORED

   • EXPIRED

   • DELETED

   • INFO_REQUESTED

   • WITHDRAWN

   • SUSPENDED