Metrics, business indicators and analytics in Oracle BPM

05 Sep

Oracle BPM is build upon the same Oracle Fusion Middleware infrastructure as Oracle SOA Suite and therefor integrates with many of it components. One of these components, Oracle BAM, can be used for business activity monitoring. But Oracle BPM comes with some integrated features for process analytic purposes as well.

Sooner or later in your BPM project you will find yourself in the situation where the business requires some metrics about the business process and task performance. Or at least, they should be. Oracle documentation about how to use process analytics can be found here. The Oracle BPM product comes with some default metrics out of the box. However you can add upon these by configuring your own business indicators. These metrics can be set on project, process and all the way down to activity level. The interesting thing about the BPM/SOA/BAM infrastructure is that the analytic mechanism works in 2 ways. When configuring the business indicators for your process you have the option to configure 2 data targets, namely:

  • Enable Cubes
  • Enable BAM
Oracle BPM analytics data targets

Oracle BPM analytics data targets

Below picture shows an high level overview of the flows of these metrics through the Oracle Fusion Middleware infrastructure for BPM/SOA & BAM.

Oracel BPM data target overview

Oracel BPM data target overview

Below 2 paragraph give a quick insight regarding the role for both options:

Real-time dashboards: The role for BAM is allowing real-time dashboards to get “RIGHT NOW” insight in your organizations processes. The “enable BAM” option allows you to send metrics to the Oracle BAM adapter which stores them in the ORABAM schema. These metrics will be the primary source for your Oracle BAM Active Data Cache (BAM ADC). The BAM ADC is designed and optimized to handle large amounts of data in real time. Data coming into Oracle BAM ADC immediately updates all defined calculations and aggregates in real time in an in-memory cache so that this data can be pushed as quickly as possible to Oracle BAM dashboards and reports (quote: Oracle). How to configure BAM for BPM is documented by Aldo Schaap in this blogpost. Oracle BAM is a good extension for the BPM infrastructure to get .

Business Intelligence (BI): The Enable Cubes setting has another important but different function. When enabling this setting the Oracle BPMN Engine will start storing the business indicators of the process into the CUBE tables in your SOAINFRA schema. These CUBE tables are full with references, hardly readable, considered internal SOAINFRA infrastructure and better left alone. However they are the source for the Oracle Process Star schema views. These process views are perfectly documented by Oracle and will probably be the most important source for your Business Intelligence (BI) information.

Oracle BPM process star views

Oracle BPM process star views

The views are based upon the CUBE tabels and show the overlapping result of all analytic information from all of your processes. Because many of the processes will have different business indicators, almost none of the views above will have specific custom information (your own metrics) available. To solve this problem, Oracle has added something in BPM version (PS6).

We now have an additional configuration option for our processes during design time. By configuring the Analytics View Identifier the BPM infrastructure this will create views for the specific process with the name mentioned in the Analytic View Identifier.

Analytics View Identifier

Analytics View Identifier

After deploying the BPM application you will find the new database analytics views generated in your SOAINFRA schema. These specific views will contain the named columns for the business indicators you configured in your process. This is an excellent out-of-the-box mechanism to publish your business intelligence information with custom metrics without having to create custom views yourself on the internal cubes.

Oracle BPM proces star analytics view

Oracle BPM proces star analytics view

Since you most likely don’t want to store this information in the SOAINFRA schema for decades, it’s best to create a strategy to extract the necessary information to a simple separate database (warehouse) or a Business Intelligence solution.

Interesting facts:

  • When you do a redeployment of your BPM project, and decide to leave the “keep running instances on after redeployment” not selected, your process information will be removed from the cubes. As a result your BI views will show no historical information anymore. So watch out for this in production.
  • The generic Oracle BPM process star views are always available in SOAINFRA, however the process specific views created due to the analytics view identifier are not (as mentioned earlier). When you redeploy your BPM process (no matter what selection you made mentioned here above regarding keeping instances), your process specific views will be dropped, and recreated. Which is not unexpected due to the fact the view will hold specific columns based on the metrics in your process and can’t keep track of the changes in JDeveloper. However this is a bit annoying when you have created grants on these SOAINFRA views to access them from another schema.



Posted by on 05-09-2013 in BPM, Oracle


Tags: , , ,

3 responses to “Metrics, business indicators and analytics in Oracle BPM

  1. Sylvain GROSJEAN

    07-10-2013 at 15:49

    Thanks Jan for this interesting Post. I see you are working now on OBPM.
    Sylvain from the OEP OOW workshop ;)

    • jvzoggel

      07-10-2013 at 16:28

      Hi Sylvian! I sadly missed OOW this year.
      Yes working on Oracle BPM 11g for about a year now.
      We also use SOA, OSB, ADF and WCC so it’s all very red around here ;-)
      regards Jan


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: