IBM FileNet P8, Version 5.2.1            

Workbench objects for monitoring recent historical data

Use the IBM® Cognos® Real-time Monitoring Workbench to view the Case Monitor workbench objects for cases, tasks, work items, and workflows in the current quarter. The historical data streams retrieve data from the Case Analyzer database every 60 seconds. You can change the interval in the data stream editor.

For monitoring recent historical data in the Case Monitor project, the view data contains the last row of the last query in the data stream.

Table 1. Workbench objects for views and data streams for monitoring recent historical data
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case Load View Task Load View Productivity View

Queue Load View

Work Load View
Case Load Data Stream Task Load Data Stream Productivity Data Stream

Queue Load Data Stream

Work Load Data Stream

Table 2. Workbench objects for lookup tables and dimensions for monitoring current data
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

Table 3. Workbench objects for lookup tables and dimensions for monitoring recent historical data
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case Load Month Lookup Task Load Month Lookup Productivity Month Lookup

Queue Load Month Lookup

Work Load Month Lookup
Case Load Month Dimension Task Load Month Dimension Productivity Month Dimension

Queue Load Month Dimension

Work Load Month Dimension
Case Load Week Lookup Task Load Week Lookup Productivity Week Lookup

Queue Load Week Lookup

Work Load Week Lookup
Case Load Week Dimension Task Load Week Dimension Productivity Week Dimension

Queue Load Week Dimension

Work Load Week Dimension

Table 4. Workbench objects for cubes for monitoring recent historical data
Objects related to cases Objects related to tasks Objects related to work items Objects related to workflows
Case Load Cube Task Load Cube Productivity Cube

Queue Load Cube

Work Load Cube

Case load data stream

The Case Load Data Stream object retrieves summary information about recent cases in the current quarter. It uses the following query to retrieve information from the Case Analyzer V_F_DMCaseLoadNearTerm view.
select DMCase_key, 
       DMUser_key, 
       DMCaseType_key, 
     Incoming, Outgoing, 
       TimeUsage,
       Month, 
       MonthNumber, 
       Week, 
       WeekNumber, CaseLoad_key
from V_F_DMCaseLoadNearTerm  
order by CaseLoad_key    

Task load data stream

The Task Load Data Stream object retrieves summary information about recent tasks in the current quarter. It uses the following query to retrieve information from the Case Analyzer V_F_DMTaskLoadNearTerm view.
select DMCase_key, 
       DMUser_key, 
       DMTaskType_key, 
       TaskLoad_key,
     Incoming, Outgoing, 
       ProcTotalMinutes, 
       WaitTotalMinutes, 
       ReadyTotalMinutes, 
       FailTotalMinutes,
       Month, MonthNumber, 
       Week, WeekNumber  
from V_F_DMTaskLoadNearTerm  
order by TaskLoad_key

Productivity data stream

The Productivity Data Stream object retrieves summary information about recent work items. It uses the following query to retrieve information from the Case Analyzer V_F_DMProductivityNearTerm view.
select DMStep_key, 
       DMUser_key,  
       DMOperation_key, 
       TotalWaitTimeMinutes, 
       TotalProcTimeMinutes, 
     Completed, Productivity_key,
       Month,
       MonthNumber,
       Week,
       WeekNumber
from V_F_DMProductivityNearTerm 
order by Productivity_key 

Queue load data stream

The Queue Load Data Stream object retrieves summary information about recent work items. It uses the following query to retrieve information from the Case Analyzer V_F_DMQueueLoadNearTerm view.
select DMOperation_key,
       DMUser_key, 
       DMStep_key, 
       Month,
       MonthNumber,
       Week,
       WeekNumber,
     Incoming, Outgoing, 
       QueueLoad_key
from V_F_DMQueueLoadNearTerm
order by QueueLoad_key 

Work load data stream

The Work Load Data Stream object uses the following query to retrieve the number of incoming and outgoing workflows in the current quarter, and the completion time for workflows in the current quarter from the Case Analyzer V_F_DMWorkloadNearTerm view.
select Workload_key, 
       DMWorkClass_key, 
     Incoming, Outgoing, 
       TimeUsage as CycleTimeMinutes ,
       Month, 
       MonthNumber,
       Week, 
       WeekNumber 
from V_F_DMWorkloadNearTerm 
order by Workload_key  


Last updated: October 2015
bas_wip_4.htm

© Copyright IBM Corporation 2015.