This topic describes the set of objects provided in OOTBConfiguration.jar for monitoring active work items and workflows. See Import the BAM project for instructions for importing this project into your BAM system.
The following table lists the OOTBConfiguration dashboard objects for work items and workflows.
Objects related to work items | Objects related to workflows | |
---|---|---|
Dashboards: | Work Items | Workflows |
Dashboard objects: | Number of active work items | Number of active workflows |
Average processing time for active work items | Average processing time for active workflows | |
Average idle time for active work items | ||
Average total processing time for active work items |
In FileNet Business Activity Monitor (BAM) , the following objects gather and assemble the business data for display in BAM dashboard objects:
The following table lists the OOTBConfiguration FileNet Application Workbench objects for work items and workflows.
Objects related to work items | Objects related to workflows | |
---|---|---|
Cubes, views, and events:
See Contexts and dimensions for more information. |
Work Item Cube Work Item View Work Item Event |
Workflow Cube Workflow View Workflow Event |
Contexts and dimensions: | Queue_Context/Queue_Dimension UserName_Context/UserName_Dimension Workflow_Context/Workflow_Dimension WorkflowDefinition_Context/WorkflowDefinition_Dimension |
The Work Item Event retrieves summary information about active work items. It uses the following query to retrieve information from the Process Analyzer F_DMWIP table.
select DMStep_key,
DMOperation_key,
DMUser_key,
Count(*) as WorkItemCount,
avg(WaitCurrentMinutes+MinutesSinceLastEvent*IsInWaitStatus) as avgIdleTime,
avg(ProcCurrentMinutes+MinutesSinceLastEvent*IsInProcStatus) as avgProcTime
from F_DMWIP
group by DMOperation_key, DMStep_key, DMUser_key
Since this is an aggregate query, any additions to the selected fields must contain an aggregate function or be added to the group by clause.
Workflow Event uses the query below to retrieve the number of active workflows and the average processing time for active workflows from the Process Analyzer F_DMWorkflowWIP table, with additional reference information retrieved from the Process Analyzer D_DMWorkflow table.
select d.DMWorkClass_key,
Count(*) as WorkflowCount,
avg(f.MinutesSinceCreation) as avgProcTime
from F_DMWorkflowWIP f, D_DMWorkflow d
where d.Workflow_key = f.Workflow_key
group by d.DMWorkClass_key
Since this is an aggregate query, any additions to the selected fields must contain an aggregate function or be added to the group by clause.