https://training-course-material.com/index.php?action=history&feed=atom&title=JBPM_6_-_1.5_-_BAMJBPM 6 - 1.5 - BAM - Revision history2026-05-13T23:54:40ZRevision history for this page on the wikiMediaWiki 1.45.1https://training-course-material.com/index.php?title=JBPM_6_-_1.5_-_BAM&diff=22868&oldid=prevFilip Stachecki: /* Create Page */2014-10-02T14:22:51Z<p><span class="autocomment">Create Page</span></p>
<p><b>New page</b></p><div>{{Cat|jBPM}}<br />
=JBPM 6 - 1.5 - BAM=<br />
== Summary ==<br />
* How to find meaningful statistics related to process variables<br />
[[File:JBPM BAM.png]]<br />
<br />
== Instructions ==<br />
# Dahboards<br />
# Business Dashboards<br />
# Login in as krisv/krisv<br />
# Administration -> Data Providers<br />
# Check if '''jBPM Process Summary''' exists (go to Instances by process), if not create one<br />
# Create new data provider <br />
# Fill out the query and name as below:<br />
<br />
: Name: jBPM Process Summary, Type: SQL Query<br />
: Query:<br />
select processinstanceid,<br />
processname,<br />
status,<br />
start_date,<br />
end_date,<br />
user_identity,<br />
processversion,<br />
duration<br />
from processinstancelog<br />
<br />
== Instances by process ==<br />
#Change workspace to jBPM Dashboard<br />
:[[File:ProcessDashboard.png | 660px ]]<br />
<br />
== Report based on custom variables ==<br />
Browse database structure<br />
cd /opt/jbpm-installer<br />
ant stop.demo<br />
cd /opt/jbpm-installer/db/driver <br />
java -jar h2.jar<br />
Change database to jbpm or other location where it is (JDBC URL)<br />
JDBC URL: jdbc:h2:~/jbpm<br />
<br />
[[File: H2connection.png]]<br />
<br />
<!-- Go to the database browser<br />
http://127.0.1.1:8082<br />
--><br />
<br />
Find VARIABLEINSTANCELOG <br />
Click on it and run<br />
SELECT * FROM VARIABLEINSTANCELOG<br />
<br />
== Create Data Provider ==<br />
# Dashboards / Business Dahsboards<br />
# Workspace: Showcase<br />
# Administration / Data Providers / Create new data provider<br />
# Type: SQL Query<br />
# Name: Process Variables<br />
# Paste the query: <br />
SELECT * FROM VARIABLEINSTANCELOG;<br />
== Create Page ==<br />
# Page: Click on the "Create new page icon"<br />
# Title: Process Variables Analysis<br />
# Go to Workspace<br />
# Choose Page: Process Variables Analysis<br />
# Create new panel in current page<br />
# Click on Key Performance Indicator<br />
# Drag "Create Panel" to the CENTER_1 side area <br/>[[File:BusinessDashboardKPI.png | 660px ]]<br />
# Choose Process Variables data source<br />
## KIP's name: Variables<br />
## Domain X Axis: value<br />
## Rage (Y Axis): variableid<br />
## Change type pie chart<br />
:[[File:BusinessDashboardChart.png | 660px ]]<br />
<br />
=== Create Filters ===<br />
# Create new panel<br />
# Filter & Drill-down<br />
# Drag it to the left hand side<br />
# Click on the cog and Edit Content<br />
# Tick ''processid'' and ''variableid''<br />
:[[File:BusinessDashboardFilter.png | 660px ]]<br />
The final view:<br />
:[[File:BusinessDashboardFinal.png.png | 660px ]]<br />
<br />
== More Information ==<br />
http://docs.jboss.org/jbpm/v6.0/userguide/chap-bam.html</div>Filip Stachecki