Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Creating a custom business activity monitoring user interface using DB2 Alphablox Query Builder

Manisha Sharma Kohli (shmanisha@in.ibm.com), Consulting IT Specialist (BPM), IBM
Manisha Sharma Kohli is a BPM architect in the World Wide WebSphere Business Partners Organization, which is a part of IBM Software Group. She has almost 10 years of experience in the IT industry, and her area of specialization includes the complete IBM WebSphere BPM portfolio, covering WebSphere Business Modeler, WebSphere Process Server (now part of IBM Business Process Manager V7.5), WebSphere Business Monitor, WebSphere Business Services Fabric, IBM BlueWorks Live, WebSphere Business Space and ILOG BRMS.

In her current role, Manisha works with IBM's strategic business partners to drive their technology adoption, support them on proof of concepts (POCs), request for proposals (RFPs), architecture development and enablement. She has successfully led several partner and customer engagements and is a well-known BPM subject matter expert in IBM and the partner community.

Manisha is also an avid innovator and has made significant contributions to IBM's intellectual property, including patents, the Technical Experts Council (Academy of Technology affiliate) and forums like developerWorks. Manisha can be reached at shmanisha@in.ibm.com.

Summary:  In this tutorial, you'll learn about the powerful features of the DB2® Alphablox Query Builder, included with WebSphere® Business Monitor, to build a custom user interface for monitoring solutions. This approach is useful when you don't want to use Business Space, but need an interface that's easy to customize to your desired look and feel, or when you want to embed the monitoring application into an existing UI.

Date:  17 Aug 2011
Level:  Intermediate

Activity:  4563 views
Comments:  

Before you start

Learn what to expect from this tutorial, and how to get the most out of it.

About this tutorial

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.


Objectives

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.

Prerequisites

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.


System requirements

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

1 of 9 | Next

Comments



Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=WebSphere
ArticleID=752549
TutorialTitle=Creating a custom business activity monitoring user interface using DB2 Alphablox Query Builder
publish-date=08172011
author1-email=shmanisha@in.ibm.com
author1-email-cc=crothemi@us.ibm.com

Tags

Help
Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).

My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Use the search field to find all types of content in My developerWorks with that tag. Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere). My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Try IBM PureSystems. No charge.