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

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

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

Table 3. Cube objects related to work items and workflows
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

The 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.
This data stream uses the following query to retrieve information from the Case Analyzer 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.

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.



Last updated: October 2015
adv_buckets_2.htm

© Copyright IBM Corporation 2015.