To monitor business data from your workflows, you configure workflow data fields as measures or dimensions on the Business Activity Monitor project.
(The Process Analyzer database provides the data stream for the BAM project.)
The event log is the input for Process Analyzer.
TIP You can start with either Process Designer or Process Configuration Console to define the data fields, but the field name and data type must match exactly.
NOTE Since BAM uses data from Process Analyzer, the data fields must be exposed as measures or dimensions to the various fact table/cubes of Process Analyzer. See Manage Process Analyzer data fields for additional information regarding exposing the data fields to the event log using Process Configuration Console, and configuring the fields for Process Analyzer.
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 Process Analyzer aggregated using the sum function) and Location (representing a dimension on 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.
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
See Business Activity Monitor example for detailed instructions for exposing the fields, configuring Process Analyzer, and setting up the BAM project to monitor user-defined fields.
The following table tracks the names assigned to a dimension and a measure as they work their way through Process Analyzer and BAM.
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 |