IBM FileNet P8, Version 5.2.1            

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

Table 1. View and data stream workbench objects related to cases and workflows
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

Table 2. Lookup table and dimension workbench objects related to cases and workflows
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.

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



Last updated: October 2015
adv_thresholds_2.htm

© Copyright IBM Corporation 2015.