Use the Business Intelligence Reporting Tool with DB2 Data Warehouse Edition, Part 2: Create basic reports and charts

Level: Introductory

Vaibhav Srivastava (vaibhav.srivastava@in.ibm.com), Staff Software Enginner, IBM　

12 Jul 2007

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

Business Intelligence and 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 this tutorial

• Create a basic BIRT report and chart in the DWE Design Studio and deploy them in WebSphere Application Server.
  
  
• Convert the reports into PDF and CSV format.
  
  
• Find out how the BIRT plug-in works
  

Objectives

• Create basic BIRT reports and charts in DB2 Data Warehouse Edition (DWE) and then view them in a Web browser.
  
  
• Go through the process of converting the reports into PDF and CSV format.
  

Prerequisites

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 Part 1 of the tutorial:

• 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

You can find these steps in the previous tutorial "Installing BIRT and Sample Data in Design Studio" (developerWorks, April 2007).

System requirements

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

Before starting this tutorial, you should already have the following in place:

• 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.

Duration

1 hour

Formats

Tutorial overview

This tutorial demonstrates how to create a basic report and chart using BIRT in Design Studio.

This tutorial explains the following tasks:

• Before creating your first BIRT report:
  • Create a BIRT project
  • Create a library
  • Create a data source
  • Create a master page
• Create the first BIRT report (Daily Sales Report):
  • Link the library to the report
  • Create a data set with computed columns and parameters:
    • Create a data set
    • Add computed columns to the data set
    • Create query parameters
    • Use parameters in a query
  • Create the report layout
  • Customize the report:
    • Add parameters to the report page
    • Enable report pagination
    • Create summary calculations
  • Format and style the report:
    • Format report data
    • Style report data
    • Make the query interactive
• Create your first chart:
  • Create calculated members for the chart
  • Select a chart type
  • Select the data to chart
  • Format the chart:
    • Apply x-axis grouping
    • Control the Legend and Data Point display
• Deploy and view the reports in WebMode:
  • View as a Web report in Design Studio
  • View the report in Excel
  • Run the reports in WebSphere

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

Back to top