Before you start
Learn what to expect from this tutorial, and how to get the most out of it.
This article presents a simple scenario for using the DB2 Alphablox Query Builder tool to build a custom JSP-based web application rather than using WebSphere Business Space to pull the dimensional data from the Monitor cubes in the WebSphere Business Monitor (hereafter called Monitor) database.
The Dimensions widget supplied with Business Space is a monitoring widget that provides out-of-the-box capabilities to enable dimensional analysis of the monitored data. So for example, if you want to measure the total number of orders processed, you can combine this data with certain categories, such as "country", to measure total nunmber of orders processed in France or Japan, and so on.
While building a business activity monitoring solution, developers and architects do not always want to use the built-in Dimensions widget supplied with Business Space, and would rather build their own custom user interface to provide more flexible analytical capabilities for the monitored data.
The solution described in this tutorial is particularly useful for scenarios in which developers are willing to build a custom UI to retrieve dimensional data and are able to provide the same analytical capabilities in their user applications as are provided by Business Space. For information on the concepts used in multidimensional modeling in a monitoring application, refer to Dimensional analysis in business activity monitoring (BAM), Part 1: Leverage WebSphere Business Monitor V6.2 to perform dimensional analysis.
Note: The example in this tutorial was built using WebSphere Business Monitor V6.2. You can successfully migrate and run models built in this tutorial in WebSphere Business Monitor V7 and IBM Business Monitor V7.5. However, Alphablox is deprecated in IBM Business Monitor V7.5. Instead, we strongly recommend that customers use the embedded Cognos® Business Intelligence capability for building custom analytical reports. Your existing monitor model definitions are compatible with Cognos-based reports and you will benefit from a much wider array of custom report authoring capabilities using the embedded Cognos Business Intelligence feature. Refer to the Business Process Manager V7.5 Information Center for more information.
In this tutorial, you will learn how to:
- Use the Alphablox Query Builder tool to write queries to retrieve data from the Monitor cubes.
- Create a JSP-based web application to present the queried cube data in the desired format, similar to the Dimensions widget of Business Space.
This tutorial is written for business activity monitoring application developers whose skills and experience are at an intermediate level. You should have a familiarity with the dimensional and analytical capabilities of Monitor and should also have experience working with the monitoring widgets in Business Space.
To run the examples in this tutorial, you need a Microsoft® Windows® computer with the following products installed:
- WebSphere Integration Developer V6.2
- WebSphere Business Monitor Toolkit and WebSphere Business Monitor server test environment V6.2 on top of WebSphere Integration Developer for the development of monitoring application
The screen shots and steps in this tutorial are based on WebSphere Integration Developer V6.2. If you want to build a solution using a standalone Monitor server, you will also need the following software:
- WebSphere Business Monitor server V6.2 to run the monitoring application
- WebSphere Process Server V6.2 to run the process and BPEL application

