Use the Business Intelligence Reporting Tool with DB2 Data Warehouse Edition, Part 3: Create complex reports with BIRT

Level: Intermediate

Vaibhav Srivastava (vaibhav.srivastava@in.ibm.com), System Software Engineer, IBM　

27 Sep 2007

	Register now or sign in using your IBM ID and password.

Business Intelligence Reporting Tool (BIRT) is an open source relational reporting solution. It provides an Eclipse-based plug-in for report development and testing, and it provides J2EE deployment and APIs that can be used in custom Java applications. With IBM® DB2® Data Warehouse Edition (DWE), use DWE Design Studio to seamlessly integrate the BIRT development environment and then deploy those reports to a WebSphere® server. In part 3 of this series, learn to create complex reports using BIRT.

Objectives

• Create summary-only reports
  
  
• Create grouped reports
  
  
• Construct and use traffic lights
  
  
• Design complex two pass calculations
  

Prerequisites

Share this... Digg this story Post to del.icio.us Slashdot it!

This tutorial assumes familiarity with some basic concepts of the Eclipse IDE, including views, editors, and panels.

Before you begin, complete the following basic installation and configuration steps from the first tutorial "Installing BIRT and Sample Data in Design Studio" (developerWorks, April 2007):

• Install BIRT Report Designer v2.1.1 in DWE Design Studio 9.1.1
• Create the DWE sample olapanddatamining
• Create the additional V_SALES and V_SALES_GROUPED SQL views
• Install BIRT under WebSphere Application Server V6.0
• Connect to the DB2 sample data by using the supplied sample report

This tutorial reuses many of the artifacts created in Part 2 of the series, so it is assumed that the user has either gone through that tutorial or has access to the sources attached with it. It is a good idea to have Part 2 open while you read this tutorial, as you will need many of the artifacts created there.

System requirements

• You must have DB2 Data Warehouse Enterprise Edition 9.1.1 installed with Design Studio 9.1.1, and you must have access to WebSphere Application Server V6.0.
• You must have access to the DWE sample data (This tutorial uses the DWESAMP database that was created in the first part of this series.)
• You must be able to access the BIRT open source product and install it into your DWE Design Studio environment. (This tutorial uses BIRT V2.1.1.)
• To run the examples in this series, you need a Windows® system with at least 512MB of free memory space.

Formats

Share this.... Digg this story del.icio.us Slashdot it!

Back to top