login url is http://localhost:port/bam/composer
Looks excellent -
We have 3 main roles - Viewer, Admin and Designer
Here is what our admin manages -
So now some basic 12c concepts - (text taken from the BAM docs)
What does BAM 12c give us?
Event Stream Analytics and Alerts
Oracle BAM provides real-time pattern matching, trend analysis, rolling-window
computations, and both static and dynamic thresholds. The built-in Continuous Query
Language (CQL) engine evaluates incoming event streams against business
requirements and data patterns of interest. You can define these patterns with
easy-to-use business query and Key Performance Indicator (KPI) templates, insulated
from the underlying CQL. Furthermore, you can archive the event streams for fuller
Based on these data patterns, you can implement a wide variety of alerts and actions,
such as emailing particular users, recording data, or launching a web service. You can
even daisy-chain alerts and define custom actions.
Process Analytics and Dashboards
Oracle BAM provides a rich set of ready-to-use dashboards for all major components
of Oracle Business Process Management (BPM) and Oracle Service-Oriented
Architecture (SOA) Suite. These dashboards include metrics such as task queue depth
and bottleneck analysis of business processes.
Business Friendly Charts
With the adoption of Oracle Application Development Framework (ADF) Data
Visualization Tool (DVT) components, Oracle BAM offers a wide range of intuitive
visualizations that you can include in dashboards, including treemaps, scatter charts,
bubble charts, and KPI watchlists.
So now to a simple example -
Creating Data Objects
A simple data object is used as is. It can contain indexes and hierarchies, but no
other column additions or modifications. It corresponds to a database view in the
BAM database. Other data objects can use or refer to simple data objects.
Administrators create simple data objects for very basic data.
extends a simple data object or another derived data object. It
inherits the columns and hierarchies of the parent data object and adds its own
columns. Administrators create derived data objects if additional columns are needed.
An external data object references data that is persisted outside of Oracle BAM.
When a connection to the external data object is configured in Oracle WebLogic
Server, Oracle BAM can access it. The external data object name may be changed
from the actual table name, but the column names are unchanged. Some columns
may not be selected for visibility in BAM.
A logical data object references data in other archived relation data objects. Unlike
a derived data object, it is read-only and not a physical data object. However, it can
do more than add columns. It can rename or hide columns, or add calculated
columns. It can also join two or more simple or derived data objects. Typically, in
compliance with process star schema standards, one source data object is a fact
table consisting of measures, while the others are dimension tables.
Administrators create logical data objects to modify columns or to enable queries
of data from two or more data objects.
Simple, derived, and external data objects are physical data objects, which can be
modified and are mapped to database tables. A logical data object is read-only, is not
persisted, references data in other data objects, and is most commonly used to join
other data objects.
Before you can use a data object with other BAM entities such as queries and
dashboards, you must create a project. A project references one or more data objects
and contains entities based on these data objects.
Continuous Query Type -
Stream or Relation - I choose relation as this is a simple example.
Specify maximum numbers of columns with different data types - I just accept the defaults here.
Now I add a couple of columns - these 3 are pre-seeded.
attribute - A data field that can be used for filtering or references
dimension -A data field that provides a type of grouping on which aggregation is performed, used
for drilling. For example, order dimensions might be supplier and product.
measure - A numeric data field that can be measured and used in comparisons to evaluate
business processes e.g. orderValue.
I now add some demo data
Designing a basic Dashboard
I now go to the Designer Tab - and create a new project -
btw. Create BPM Example — Creates a project with data objects for Oracle
Business Process Management (BPM) processes.
I click Create
Now, I add my data object to the project.
I now create a Dashboard
I add a pie chart to the dashboard.
I link it to the business query.
Click Apply and it's done!
I add two more views -
In order to set the threshold, I clicked on the business view editor icon - that is the one in the middle
Click on Display Properties
The viewer clicks on the Home link
Here I open my recently created project and then the dashboard