IBM FileNet P8, Version 5.2.1            

Workbench objects for monitoring current data

Use the IBM® Cognos® Real-time Monitoring Workbench to view the Case Monitor workbench objects for cases, tasks, work items, and workflows that are currently in progress.

For monitoring current data in the Case Monitor project, the view data is essentially the same as the data stream data, except that some formatting is done in the view.

Table 1. Workbench objects for views and data streams
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case View Task View Work Item View Workflow View
Case Data Stream Task Data Stream Work Item Data Stream Workflow Data Stream

Table 2. Workbench objects for lookup tables and dimensions
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case State Lookup Task State Lookup Queue_lookup Workflow Lookup
Case State Dimension Task State Dimension Queue_dimension Workflow Dimension
Case Type Lookup Task Type Lookup UserName_lookup Workflow Definition Lookup
Case Type Dimension Task Type Dimension User_dimension Workflow Definition Dimension

Table 3. Workbench objects for cubes
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case Cube Task Cube Work Item Cube Workflow Cube

Case data stream

The Case Data Stream object retrieves summary information about active cases. It uses the following query to retrieve information from the Case Analyzer V_F_DMCaseWIP view.
select f.DMCaseType_key,
     f.DMUser_key , 
     f.DMCaseState_key,
     Count(*) as caseCount, 
     avg(f.MinutesSinceCreation * 1.0) as minutesSinceCreation
from V_F_DMCaseWIP f
group by  f.DMCaseType_key, DMUser_key,DMCaseState_key

Task data stream

The Task Data Stream object retrieves summary information about active tasks. It uses the following query to retrieve information from the Case Analyzer V_F_DMTaskWIP view.
select DMTaskType_key, 
     DMUser_key, 
     DMTaskState_key, 
     Count(*) as TaskCount,
     avg(WaitCurrentMinutes+MinutesSinceLastEvent*IsInWaitStatus) avgWaitTime , 
     avg(ProcCurrentMinutes+MinutesSinceLastEvent*IsInProcStatus) as avgProcTime ,
     avg(ReadyCurrentMinutes+MinutesSinceLastEvent*IsInReadyStatus) as avgReadyTime , 
     avg(FailCurrentMinutes+MinutesSinceLastEvent*IsInFailStatus) as avgFailedTime 
from V_F_DMTaskWIP
group by DMTaskType_key, DMUser_key, DMTaskState_key

Work Item data stream

The Work Item Data Stream object retrieves summary information about active work items. It uses the following query to retrieve information from the Case Analyzer V_F_DMWIP view.
select DMStep_key,
     DMOperation_key, 
     DMUser_key, 
     Count(*) as WorkItemCount, 
     avg(WaitCurrentMinutes+MinutesSinceLastEvent*IsInWaitStatus) as avgIdleTime,
     avg(ProcCurrentMinutes+MinutesSinceLastEvent*IsInProcStatus) as avgProcTime 
from V_F_DMWIP 
group by DMOperation_key, DMStep_key, DMUser_key

Because the query is an aggregate query, any additions to the selected fields must contain an aggregate function or be added to the group by clause.

Workflow data stream

The Workflow Data Stream object uses the following query to retrieve the number of active workflows and the average processing time for active workflows from the Case Analyzer V_F_DMWorkflowWIP view. Additional reference information is retrieved from the Case Analyzer D_DMWorkflow table.
select d.DMWorkClass_key,
     Count(*) as WorkflowCount,
     avg(f.MinutesSinceCreation) as avgProcTime
from V_F_DMWorkflowWIP f, D_DMWorkflow d 
where d.Workflow_key = f.Workflow_key
group by d.DMWorkClass_key

Because the query is an aggregate query, any additions to the selected fields must contain an aggregate function or be added to the group by clause.



Last updated: October 2015
bas_wip_3.htm

© Copyright IBM Corporation 2015.