Within my latest project I had the opportunity to get acquainted with BAM, and I’d like to share my enthusiasm about the product with you. Oracle acquired BAM as part of the Peoplesoft take-over in 2006. It was a hidden gem, which came out as a surprise. Having it’s first implementation in .Net it is now transferred to a Java implementation and part of the SOA Suite. BAM allows you to look at your business using Real-Time information! Thus making you able to Monitor your business services and processes and take immediate corrective actions if needed. Before you start downloading, installing and integrating BAM in your system landscape lets first take a look at the positioning of BAM in the Business Intelligence(BI) Landscape. When it comes to BI you can split the landscape into three pieces, Tactical, Strategic and Operational. BAM is a powerful ally when it comes to both Operational and Tactical Monitoring. Strategic intelligence often requires long-term data collection with millions of lines and doesn’t require you to look at your diagrams on daily or weekly base. Most (business) users would definitely require more advanced ETL processes than BAM can support. In this blog I will elaborate on some of BAM’s functionality.

BAM your Business Before you start to use any BI tool it is important that you have a good idea of which KPI’s you are aiming for. Especially it is important to map your data model to your KPI’s and make available what you need in Oracle BAM. When you have done this the hard part is finished!

BAM is an out of the box, drag and drop user-friendly Business Intelligence tool. After installation you get a set of standard diagrams, which usually allow most users to gain insight in their KPI’s. But this is also one of the disadvantages. If you want to customize more than BAM gives you out of the box, it would require ADF knowledge to do so. After logging into BAM you see four main buttons, which represent the different ingredients you need for a BAM report. The Administrator section is used for user and distribution management. Architect is used to setup Data Connections, create Data Objects and set Alerts. The Active studio enables you to create and maintain reports, which can be actively viewed after creation in the Active Viewer. This blog will focus primarily on the Active Studio and Viewer and show you how easy it is to create reports and diagrams.

How it works After logging in and navigating to the Active Studio you will find the recently opened and shared reports, which allows you to quickly open the reports you have currently worked on. From here we can also create a new report by clicking on the button.

BAM has a set of standard formats for reports, but of course these are fully adjustable and you can have as many or as few graphics as you want on your report. For this example I have picked a report with three spaces in it. Now to make it even easier, I can pick any of the diagrams and set up my diagrams step-by-step.

After double clicking on the 3D Bar Diagram you need to perform 3 steps to finalize your diagram. In my example I’m going to show 4 Countries and perform a count function on the InterfaceID.

After finishing all three steps, the creation of the bar diagram is completed! On the example below I repeated the steps for all three parts of the report.

BAM Viewer
After saving your report you can view it in the BAM Viewer. Now the cool thing is, that whenever there is a new event in your system- or process landscape, you will see that your diagrams change with it. This means you are always up-to-date with the latest Business Intelligence!

Start to BAM now!
Oracle BAM is an easy out of the box Business Intelligence tool where you can create your own reports in just minutes using live data. There are many other options available such as: the ability to drill down, personalize the report and the option to use dynamic filters on your diagrams and much more, which I will cover in the next blog. Stay tuned, and if you have any questions, please don’t not hesitate to send me an e-mail!

Martijn van der Kamp, Oracle developer