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.