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