Business process owners are C-level and top executives; the people who might have been directly involved in funding or reporting to the board of directors, or the people who are held directly responsible for the overall business performance. They understand, own, and run the business. Their business can be spread into different geographical locations with different lines of business coming under their enterprise. They will be interested in real-time dashboards, business intelligence, and take key decisions based on key performance indicators and other metrics.
BPM has out of the box integration with the BAM application that enables business process participants and process owners to view real-time dashboards. They can also use WebCenter Portal with its out of the box integration capabilities, along with Oracle Business Intelligence Enterprise Edition 11g (OBI EE), to view and analyze and take decisions on some of the most complex multidimensional reports.
From a business process, we can capture process-specific data that makes business sense. Some of the terminologies that need to be understood are:
Some of the measurements and dimensions that we are going to use are tabulated as follows:
Measurement name |
Description |
---|---|
Requested loan amount measurement |
This maps to the requested loan amount that was entered by the applicant during the eligibility check |
Repayment duration measurement |
This maps to the repayment period that was given during the eligibility check |
Dimension name |
Description |
Income group dimension |
The range is set as follows:
Similarly, we can create a few more dimensions such as customer type dimension and company name dimension, depending on the business requirements. |
From a business reporting requirement point of view, some the reports that make sense from a home loan perspective are:
Before we begin, the following requirements need to be fulfilled:
We will add a simple Database Adapter, Get Eligibility Details
, that fetches eligibility data based on the request ID of the applicant through an SQL query, as follows:
select PROPERTYCITY, LOANAMOUNT, LOANPURPOSE, MARKETVALUE, REPLAYMENTDURATION, AGE, EMPLOYMENTTYPE, COMPANYNAME, AVERAGEMONTHLYINCOME, CUSTTYPE, FIXEDEMI, VARIABLEEMI, REQUESTID from ELIGIBILITYDATA where REQUESTID = ?
We will add a service task activity on LoanApplicationProcess
that invokes the Get Eligibility Details
Database Adapter. We can name this service activity as Get Applicants Eligibility Details
.
We will now modify the process to add BAM data object based dimensions and measurements, and also use the BAM application to create a process dashboard.
We will select the home loan business process and add an application counter that counts the number of times the process has been executed. We can put this at the start of the process, or just while the loan application is initiated by James Cooper. To do that, let's perform the following steps:
Loan Application
initiator task and add a counter mark.We will now create the following dimensions and measurements, as discussed earlier at the start of this recipe:
LoanApplicationProj
and select Project Preferences. Under Process Analytics Summary, ensure that eis/bam/soap is selected. Also, the Enable Cubes and Enable BAM checkboxes are selected. We can select the default folder path or select a new path as required.weblogic
user at http://localhost:9001/OracleBAM/
.BI_default_<project name>_<process name>
. In our case, it will be BI_default_LoanApplicationProj_LoanApplicationProcess
.The output of this recipe uses the business process that is capable of delivering standard and customized business reports to the business process owners and the business analysts. We have created some standard and customized reports that can be viewed in the BAM dashboard.
From the BAM Active Viewer, we can view the standard and customized reports. Some of the customized reports that we have created for the process owners are shown in the following screenshot:
It would be interesting to know that BAM presents real-time reports based on data objects that get populated by one or more business processes. On the other hand, BI reports are capable of building reports from multiple data sources such as databases, XML files, Excel files, and historical data. BI reports add a layer of analysis and intelligence on top of an existing dataset. In a real-life financial services scenario, the process owner or the participants can have a combined report view of all BPM standard reports, and BI and BAM reports, on their WebCenter Portal. There can also be user- and context-based reports. Users can also personalize these reports based on their roles.