# 330 BAM 12c first impressions...and my first 12c Data Object / BAM Dashboard

I just installed BAM 12c and am now kicking the tyres -

login url is http://localhost:port/bam/composer

Looks excellent -

We have 3 main roles - Viewer, Admin and Designer

Admin

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 

analysis later.

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.

Architecture

So now to a simple example - 

Creating Data Objects 

Types -

Simple -

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.

Derived -

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.

External -

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.

Logical -

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

Designer 

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 add a business query - SupplierQuery

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

I change a couple of things and save the dashboard

Viewer

The viewer clicks on the Home link

Here I open my recently created project and then the dashboard