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
Change the poll interval to 300 seconds
CAUTION When you create a new event, you must modify the XML source for that event in order for the system to properly calculate the values returned from the query. See Enable "Clear State" for instructions. If you do not make this modification, values for each query will be added to the previous values, rather than reflect the values retrieved by the query.
(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