BAM example - Sum and average Amount by Location
This example outlines the procedure to configure
FileNet Application Workbench so that 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 (BAM) 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
- Log on to
FileNet Application Workbench.
- If you have not already done so, import the FileNet-provided OOTBConfiguration project. See Import the pre-configured Business Activity Monitor objects.
- On the Application Workbench tab, open the Events folder and select Workflow Event.
- Click Edit This Event, then modify the JDBC Query as follows: (note the comma (,) after avgProcTime)
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
Click Resubmit Query. Note that avgAmount, Location_key, and sumAmount are added to the columns for the event.
Click Save Event.
- Select the Contexts folder, and click New Context to create a context for the Location dimension.
- Context source: JDBC
- JDBC Connection: VMAEDM_JDBC_Agent
Query: select * from D_DMDatafield_Location
Click Continue.
- On Configure Context - JDBC Source, enter Name: Location_Context
On the Data Caching tab, enable Cache data for this Context.
Number of result sets to cache: 5
(Note that the expected number of results should be small to avoid excessive memory usage.)
- Add an Invalidation schedule or accept the default.
-
Click Save Context.
- Open the Views folder, then select Workflow View, and click Edit This View.
- Drag avgAmount, sumAmount, and Location_key from Workset list onto the table.
- Click Save View.
- Select the Dimensions folder, then click New Dimension
- Name: Location_Dimension
- Context Name: Location_Context
- Under Select Fields for hierarchy, select Location and move it to the Selected Fields table.
- Under Select Key field, select the Key Field checkbox for Location_key.
- Click Save Dimension.
- Open the Cubes folder and select Workflow Cube. Click Edit this cube.
- In Configure Cube, click Add Measure Column.
- Measure Name: Average Amount
Aggregate Expression: AVG("Workflow View".avgAmount)
( TIP Click the Field Builder button. Click Add Fields and select the appropriate field.)
- Measure Name: Total Amount
Aggregate Expression: SUM("Workflow View".sumAmount)
- Click Add Dimension.
- Dimension: Location_Dimension
- Dimension Primary Key: Location_key
- Fact Column Foreign Key: Location_key
- Click Save Cube.
Create a new dashboard object to display the values we want to monitor
- Log on to FileNet Operational Dashboard.
- Under Navigation Tree, select Dashboard Objects.
- Select the Dashboard Objects folder and click Create Object.
- Under Data source, select Workflow Cube. Click Continue.
- Select the following options to specify the display:
- Display type: Chart
- Display sub-type: Combination Chart
- Y-Axis
Average Amount - Line
Total Amount - Bar
- X-Axis - Location Dimension
- Click Continue.
- Default name - Average Amount and Total Amount by Location
- Click Save.
- In the Navigation Tree, select Dashboards.
- Select the Workflow dashboard and click Edit Dashboard. Select Edit Dashboard Content.
- Select Average Amount and Total Amount by Location.
Save the dashboard.
