This example outlines the procedure to configure FileNet Application Workbench so that the FileNet Operational Dashboard can display the sum and average Amount per Location for the workflows in progress. See OOTBConfiguration project objects for a description of the objects.
NOTE See Business Activity Monitor example - data source setup for the procedure for creating the workflow and exposing the data fields that provide the data stream for this example.
Define the BAM event, view, and cube in FileNet Application Workbench
select d.DMWorkClass_key, Count(*) as WorkflowCount, avg(f.MinutesSinceCreation * 1.0) as avgProcTime,
avg(f.VMAE_Amount) as avgAmount,
sum(f.VMAE_Amount) as sumAmount,
f.VMAE_Location_key as Location_key
from F_DMWorkflowWIP f, D_DMWorkflow d
where d.Workflow_key = f.Workflow_key
group by d.DMWorkClass_key, f.VMAE_Location_key
Note that avgAmount, Location_key, and sumAmount are added to the columns for the event.
Click Resubmit Query, then click Save Event.
Query: select * from D_DMDatafield_Location
Click Continue.
Number of result sets to cache: 5
(Note that the expected number of results should be small to avoid excessive memory usage.)
Click Save Context .
Aggregate Expression: AVG("Workflow View".avgAmount)
( TIP Click the Field Builder button, and click Add Fields, then select the appropriate field.)
Aggregate Expression: SUM("Workflow View".sumAmount)
Create a new dashboard object to display the values we want to monitor
Save the dashboard.