JBPM 6 - 1.5 - BAM

JBPM 6 - 1.5 - BAM

Summary

• How to find meaningful statistics related to process variables

Instructions

1. Dahboards
2. Business Dashboards
3. Login in as krisv/krisv
4. Administration -> Data Providers
5. Check if jBPM Process Summary exists (go to Instances by process), if not create one
6. Create new data provider
7. Fill out the query and name as below:

Name: jBPM Process Summary, Type: SQL Query

Query:

       select processinstanceid,
       processname,
       status,
       start_date,
       end_date,
       user_identity,
       processversion,
       duration
       from processinstancelog

Instances by process

1. Change workspace to jBPM Dashboard

Report based on custom variables

Browse database structure

cd /opt/jbpm-installer
ant stop.demo
cd /opt/jbpm-installer/db/driver 
java -jar h2.jar

Change database to jbpm or other location where it is (JDBC URL)

JDBC URL: jdbc:h2:~/jbpm

Find VARIABLEINSTANCELOG Click on it and run

SELECT * FROM VARIABLEINSTANCELOG

Create Data Provider

1. Dashboards / Business Dahsboards
2. Workspace: Showcase
3. Administration / Data Providers / Create new data provider
4. Type: SQL Query
5. Name: Process Variables
6. Paste the query:

SELECT * FROM VARIABLEINSTANCELOG;

Create Page

1. Page: Click on the "Create new page icon"
2. Title: Process Variables Analysis
3. Go to Workspace
4. Choose Page: Process Variables Analysis
5. Create new panel in current page
6. Click on Key Performance Indicator
7. Drag "Create Panel" to the CENTER_1 side area
   
8. Choose Process Variables data source
   1. KIP's name: Variables
   2. Domain X Axis: value
   3. Rage (Y Axis): variableid
   4. Change type pie chart

Create Filters

1. Create new panel
2. Filter & Drill-down
3. Drag it to the left hand side
4. Click on the cog and Edit Content
5. Tick processid and variableid

The final view:

More Information

http://docs.jboss.org/jbpm/v6.0/userguide/chap-bam.html