OOTBConfiguration project objects

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.

Dashboard objects

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  

Workbench objects

In FileNet Business Activity Monitor, 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:

  • In the OOTBConfiguration project, the view data is essentially the same as the event data, except that some formatting is done in the view.

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

Work Item Event

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

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.