The following Case Monitor workbench objects gather and assemble the business data for display in Case Monitor dashboard objects.
The following tables list the Case Monitor Threshold Monitoring workbench objects for cases and workflows.
For view and data streams, each set of threshold objects (idle time, processing time, and total processing time) uses two views based on the same event. The first view calculates the number of items that exceed the threshold. The second view provides a list of the specific items exceeding the threshold. The preconfigured threshold examples do not use any cubes.
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case Processing Time Threshold Data Stream Case Processing Time Threshold Detail View Case Processing Time Threshold View |
Task Total Processing Time Threshold Data Stream Task Total Processing Time Threshold Detail View Task Total Processing Time Threshold View |
Work Item Idle Time Threshold Data Stream Work Item Idle Time Threshold Detail View Work Item Idle Time Threshold View Work Item Processing Time Threshold Data Stream Work Item Processing Time Threshold Detail View Work Item Processing Time Threshold View Work Item Total Processing Time Threshold Data Stream Work Item Total Processing Time Threshold Detail View Work Item Total Processing Time Threshold View |
Workflow Processing Time Threshold Data Stream Workflow Processing Time Threshold Detail View Workflow Processing Time Threshold View |
Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
---|---|---|---|
Case State Dimensions Case Type Dimensions Case State Lookup Case Type Lookup |
Task State Dimensions Task Type Dimensions Task State Lookup Task Type Lookup |
Queue Lookup Queue Dimension User Lookup User Dimension |
Workflow Lookup Workflow Dimension Workflow Definition Lookup Workflow Definition Dimension |
The objects related to each set of threshold objects (idle time, processing time, and total processing time) are very similar. This section details the Work Item Total Processing Time Threshold Event object. Use IBM® Cognos® Real-time Monitoring Workbench to view the details of the other data streams.
This data stream allows you to monitor the number of active work items whose total processing time (actual processing time plus idle time) exceeds a specified threshold, in this case, three days (4,320 minutes). In addition, you can view a list of the specific work items that exceed the threshold.
select top 500 f.DMWorkItem_key,
w.WobNum,
1 as TotalTimeExceed
from V_F_DMWIP f, D_DMWorkItem w
where (WaitCurrentMinutes+ProcCurrentMinutes+IsInWaitStatus*MinutesSinceLastEvent+
IsInProcStatus*MinutesSinceLastEvent) > 4320
and f.DMWorkItem_key=w.DMWorkItem_key
Notice that the query retrieves both WobNum (the unique identifier for a work item) and TotalTimeExceed. The Work Item Total Processing Time Threshold View object uses TotalTimeExceed to determine whether a threshold has been exceeded. The Work Item Total Processing Time Threshold Detail View object uses WobNum when displaying the list of the specific work items that exceed the threshold. Only the top 500 work items exceeding the threshold are returned.
The Workflow Processing Time Threshold Event object allows you to monitor the number of active workflows whose total processing time (actual processing time plus idle time) exceeds a specified threshold, in this case, three days (4,320 minutes). In addition, you can view a list of the specific workflows that exceed the threshold.
The Workflow Processing Time Threshold Event object uses the following query to retrieve information from the Case Analyzer V_F_DMWorkflowWIP table, with additional reference information retrieved from the Case Analyzer D_DMWorkflow table.
select top 500 f.Workflow_key,
w.WobNum,
1 as ProcTimeExceed
from V_F_DMWorkflowWIP f, D_DMWorkflow w
where MinutesSinceCreation > 4320
and f.Workflow_key = w.Workflow_key
As above, the query retrieves both WobNum and ProcTimeExceed. The Workflow Processing Time Threshold View object uses ProcTimeExceed to determine whether a threshold has been exceeded. The Workflow Processing Time Threshold Detail View object uses WobNum when displaying the list of the specific workflows that exceed the threshold. Only the top 500 workflows exceeding the threshold are returned.