User-defined fields in Business Activity Monitor

To monitor business data from your workflows, you configure workflow data fields as measures or dimensions on the Business Activity Monitor project.

  1. Use the following steps to set up the data stream from your workflows to the Process Analyzer.

    (The Process Analyzer database provides the data stream for the Business Activity Monitor project.)

  2. In FileNet Application Workbench, use the following steps to configure a user-defined field as a measure or dimension .
    1. Select the Events folder, then you can modify the query of an existing event.

      For example, you can add your fields to the event query for the Workflows Event. Since this is an aggregate query, any additions to the selected fields must either contain an aggregate function or be added to the group by clause. For example, in order to view total sales by region, you would add sumAmount (representing a measure on the Process Analyzer aggregated using the sum function) and Location (representing a dimension on the Process Analyzer) to the query as shown below.

      select d.DMWorkClass_key,
        Count(*) as WorkflowCount,
        avg(f.MinutesSinceCreation) as avgProcTime,
        sum(f.VMAE_Amount) as sumAmount,
        f.VMAE_Location
      _key as Location
      from F_DMWorkflowWIP f, D_DMWorkflow d
      where d.Workflow_key = f.Workflow_key
      group by d.DMWorkClass_key, Location_key

      Fields added to an existing event, such as Workflow Event, must subsequently be added to the appropriate views and cubes, such as Workflow View and Workflow Cube.

    2. For a dimension, select the Contexts folder, and create a Context for the field. (This does not apply to a measure.)

      Select the Dimensions folder, and create a Dimension from the Context. Also configure the cache size and invalidation schedule.

      Remember that the size of the cache has direct impact on the memory usage of the BAM server

    3. Select the Views folder, and modify the view based on the event.
    4. Select the Cubes folder, and modify the cube based on the view.
    5. Enable the applicable event stream.
  3. In FileNet Operational Dashboard, create one or more dashboard objects based on the appropriate view or cube, then assign your dashboard objects to an appropriate dashboard..

See Business Activity Monitor example for detailed instructions for exposing the fields, configuring Process Analyzer, and setting up the Business Activity Monitor project to monitor user-defined fields.

Tracking a user-defined data field name through the process

The following table tracks the names assigned to a dimension and a measure as they work their way through the Process Analyzer and the Business Activity Monitor.

  Dimension Measure
User-defined field in Process Configuration Console,
Process Designer, and Process Task Manager
dname mname
In the Process Analyzer database tables VMAE_dname_key
VMAE_dname
VMAE_mname
When adding the field to the event stream query VMAE_dname_key VMAE_mname