JBPM 6 - 1.5 - BAM

From Training Material
Revision as of 14:22, 2 October 2014 by Filip Stachecki (talk | contribs) (→‎Create Page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

JBPM 6 - 1.5 - BAM

Summary

  • How to find meaningful statistics related to process variables

JBPM BAM.png

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
ProcessDashboard.png

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

H2connection.png


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
    BusinessDashboardKPI.png
  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
BusinessDashboardChart.png

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
BusinessDashboardFilter.png

The final view:

BusinessDashboardFinal.png.png

More Information

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