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.
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 |
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 |
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 |
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
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
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.
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.