Workbench objects
The following Case Monitor workbench objects gather and assemble the business data for display in Case Monitor dashboard objects.
- Data stream
- A Case Monitor data stream can be thought of as a query that
uses an agent, such as JDBC, to retrieve data from the Case Analyzer
store at a specified polling interval. Each data stream selects data from a Case Analyzer table for a specific purpose. The retrieved is held in memory in a
data stream table of the name specified for the data stream. See
Agents
in the IBM® Cognos® Business Intelligence online documentation
for instructions about configuring
an agent appropriate for your system. - View
- A Case Monitor view extracts data from the Case Monitor data stream and possibly other views to assemble the desired business model.
- Cube
- A Case Monitor cube combines the view data with the measures and dimensions.
- Lookup table
- A Case Monitor lookup table provides meaningful reference information related to a Case Monitor data stream. Lookup table information is relatively static. Like a Case Monitor data stream, a lookup table uses an agent to retrieve data from the Case Analyzer store.
- Dimension
- A dimension is a ranked order of classifications that, from highest to lowest level, describe decreasingly smaller sets of related data in a Case Monitor lookup table.
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 |
Work Item Total Processing Time Threshold data stream
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.
Work Item Total Processing
Time Threshold Event object uses the following query to retrieve
information from the Case Analyzer V_F_DMWIP table,
with additional reference information retrieved from the Case Analyzer D_DMWorkItem table.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.
Workflow Processing Time Threshold data stream
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.