In our example workflow, we have a sales amount and a location—N, E, S, or W. (See Business Activity Monitor example - data source setup for the procedure for creating the workflow and exposing the data fields.) For this example, we will monitor work items in each location, grouping them into three amount categories:
NOTE Before you continue with this example, be sure that you have completed the following steps:
Define the BAM event, view, and cube in FileNet Application Workbench
select SUM(Amount_LT_2000Count) as Amount_LT_2000Count,
SUM(Amount_2000_5000Count) as
Amount_2000_5000Count,
SUM(Amount_GT_5000Count) as Amount_GT_5000Count,
DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
from
(
select count(*) as Amount_LT_2000Count,
0 as Amount_2000_5000Count,
0 as Amount_GT_5000Count,
DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
from F_DMWIP
where VMAE_Amount<2000
group by DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
union
select 0 as Amount_LT_2000Count,
count(*) as Amount_2000_5000Count,
0 as
Amount_GT_5000Count,
DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
from F_DMWIP
where VMAE_Amount>=2000 and VMAE_AMOUNT<=5000
group by DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
union
select 0 as Amount_LT_2000Count,
0 as Amount_2000_5000Count,
count(*) as Amount_GT_5000Count,
DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
from F_DMWIP
where VMAE_Amount>5000
group by DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
)
as UnionResults
group by DMUser_key, DMOperation_key, DMStep_key, VMAE_Location_key
On the Polling tab, set the poll interval to 300 seconds.
Click the Clear State Interval tab. Select Always Clear State (Every Event).
(For work in progress, you generally want the current value of items in the queues—you don't want to add the current value detected at each polling interval to the previous value.)
From Clause should contain the name of the bucket event.
(Note that the Measure names will display in the dashboard object.)
Measure Name | Aggregate Expression |
---|---|
<2000 | SUM("Work Item Amount Bucket View".Amount_LT_2000Count) ( TIP Use the Field Builder to select the field.) |
2000-5000 | SUM("Work Item Amount Bucket View".Amount_2000_5000Count) |
>5000 | SUM("Work Item Amount Bucket View".Amount_GT_5000Count) |
Dimension | Dimension Primary Key | Fact Column Foreign Key |
---|---|---|
Location_Dimension | Location_key | VMAE_Location_key |
User_dimension | DMUser_key | DMUser_key |
Queue_Dimension | DMOperation_key | DMOperation_key |
This completes the setup tasks in Application Workbench.
Configure the dashboard object and dashboard to display the data from the Work Item Amount Bucket Cube