FileNet P8 Case Analyzer, Version 5.2.1            

Updating Case Monitor workbench objects

If you used the Case Monitor workbench objects in the 5.0 release of Case Monitor, then when you upgrade Case Analyzer to the 5.2.1 release of IBM® FileNet® P8 or IBM Content Foundation, you must update your Case Monitor projects files.

To reuse the workbench objects that monitor active cases, tasks, work items, and workflows with the current release of Case Analyzer, you must update the objects with the replacement views. For more information, see Upgrade an existing IBM FileNet Case Monitor project installation.

In the workbench objects, update the views by changing the following line of code.

Table 1. Case Monitor workbench objects that require updating with current views
Workbench object Replace... With...
Case Data Stream from F_DMCaseWIP from V_F_DMCaseWIP
Task Data Stream from F_DMTaskWIP from V_F_DMTaskWIP
Work Item Data Stream from F_DMWIP from V_F_DMWIP
Workflow Data Stream from F_DMWorkflowWIP from V_F_DMWorkflowWIP
Number of Work Items Per Bucket Data Stream from F_DMWIP from V_F_DMWIP
Number of Workflows Per Bucket Data Stream from F_DMWorkflowWIP from V_F_DMWorkflowWIP
Work Item Total Processing Time Threshold Data Stream from F_DMWIP from V_F_DMWIP
Workflow Processing Time Threshold Data Stream from F_DMWorkflowWIP from V_F_DMWorkflowWIP

For example, in the following workbench object from the IBM FileNet P8 Release 5.0 of Case Monitor, edit the Task Data Stream object file and replace F_DMTaskWIP with V_F_DMTaskWIP. The corrected object retrieves the appropriate data for your query.

Task Data Stream

select DMTaskType_key, 
   DMUser_key, 
   DMTaskState_key, 
   Count(*) as TaskCount,
   avg(WaitCurrentMinutes+MinutesSinceLastEvent*IsInWaitStatus) avgWaitTime ,
   avg(ProcCurrentMinutes+MinutesSinceLastEvent*IsInProcStatus) as avgProcTime ,
   avg(ReadyCurrentMinutes+MinutesSinceLastEvent*IsInReadyStatus) as avgReadyTime ,
   avg(FailCurrentMinutes+MinutesSinceLastEvent*IsInFailStatus) as avgFailedTime
from F_DMTaskWIP
group by DMTaskType_key, DMUser_key, DMTaskState_key


Last updated: March 2016
bpmua007.htm

© Copyright IBM Corporation 2016.