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 table lists the Case Monitor Bucket workbench objects for cases, tasks, work items, and workflows.
| Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
|---|---|---|---|
| Case Bucket View | Task Bucket View | Number of Work Items Per Bucket View | Number of Workflows Per Bucket View |
| Case Bucket Data Stream | Task Bucket Data Stream | Number of Work Items Per Bucket Data Stream | Number of Workflows Per Bucket Data Stream |
| Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
|---|---|---|---|
| Dimension | Dimension | Queue_Context | Workflow Lookup |
| Dimension | Dimension | Queue_Dimension | Workflow Dimension |
| Lookup table | Lookup table | UserName_Context | Workflow Definition Lookup |
| Lookup table | Lookup table | User_Dimension | Workflow Definition Dimension |
| Objects related to cases | Objects related to tasks | Objects related to work items | Objects related to workflows |
|---|---|---|---|
| Case Bucket Cube | Task Bucket Cube | Number of Work Items Per Bucket Cube | Number of Workflows Per Bucket Cube |
Number of Work Items Per Bucket data stream
Number
of Work Items Per Bucket Data Stream object calculates the
number of active work items whose processing time falls into one of
two groups, or buckets.- Work items with a processing time of less than 60 minutes are placed into the first bucket.
- Work items with a processing time greater than or equal to 60 minutes are placed into the second bucket.
V_F_DMWIP cube.
select SUM(ProcTimeBucket1Count) as ProcTimeBucket1Count,
SUM(ProcTimeBucket2Count) as ProcTimeBucket2Count,
DMUser_key, DMOperation_key, DMStep_key
from
(
select count(*) as ProcTimeBucket1Count,
0 as ProcTimeBucket2Count,
DMUser_key,
DMOperation_key,
DMStep_key
from V_F_DMWIP
where (ProcCurrentMinutes + MinutesSinceLastEvent*IsInProcStatus)< 60
group by DMUser_key, DMOperation_key, DMStep_key
union
select 0 as ProcTimeBucket1Count,
count(*) as ProcTimeBucket2Count,
DMUser_key,
DMOperation_key,
DMStep_key
from V_F_DMWIP
where (ProcCurrentMinutes + MinutesSinceLastEvent*IsInProcStatus)>=60
group by DMUser_key, DMOperation_key, DMStep_key
)
as UnionResults
group by DMUser_key, DMOperation_key, DMStep_key
Because this is an aggregate query, any additions
to the selected fields must contain an aggregate function or be added
to the group by clause. Because this query performs
a union, any additions to the selected fields must be added to both
of the union sub-queries as well as the primary query.
Number of Workflows Per Bucket data stream
The Number
of Workflows Per Bucket Data Stream object calculates the
number of active workflows whose processing time falls into one of
two groups, or buckets.
- Workflows with a processing time of less than 4320 minutes (3 days) are placed into the first bucket.
- Workflows with a processing time greater than or equal to 4320 minutes are placed into the second bucket.
This data stream 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 SUM(ProcTimeBucket1Count) as ProcTimeBucket1Count,
SUM(ProcTimeBucket2Count) as ProcTimeBucket2Count,
DMWorkClass_key
from
(
select count(*) as ProcTimeBucket1Count,
0 as ProcTimeBucket2Count,
DMWorkClass_key
from V_F_DMWorkflowWIP f, D_DMWorkflow d
where f.Workflow_key = d.Workflow_key and MinutesSinceCreation < 4320
group by DMWorkClass_key
union
select 0 as ProcTimeBucket1Count,
count(*) as ProcTimeBucket2Count,
DMWorkClass_key
from V_F_DMWorkflowWIP f, D_DMWorkflow d
where f.Workflow_key = d.Workflow_key and MinutesSinceCreation >= 4320
group by DMWorkClass_key
)
as UnionResults
group by DMWorkClass_key
Because this is an aggregate query, any additions to
the selected fields must contain an aggregate function or be added
to the group by clause. Because this query performs
a union, any additions to the selected fields must be added to both
of the union sub-queries as well as the primary query.