 | Level: Intermediate Vaibhav Srivastava (vaibhav.srivastava@in.ibm.com), System Software Engineer, IBM
06 Mar 2008 The 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 API 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 an IBM WebSphere® server. During
the course of this tutorial, learn how to add interactivity to your reports using
BIRT in Design Studio. Objectives - Create reports and charts, and add interactivity to them using BIRT in DB2
Data Warehouse Edition.
- Learn how to hide and sort columns at runtime.
- Create templates of a report, and then re-use the template to create
reports.
Prerequisites
This tutorial assumes you have familiarity with some basic concepts of the
Eclipse IDE, including views, editors, panels, and so on. Before you begin, complete the following basic installation and configuration
steps from
part one
of this series:
- 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, using the supplied sample report
You will be re-using many of the artifacts created in
part two
of the series, so it is assumed that you have either gone through that tutorial
or have access to the sources attached with it.
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 created in
part one
of this series.)
- You must be able to access the BIRT open source product and have it
installed 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
Formats html, pdf
Tutorial overview
This tutorial demonstrates how to add interactivity in reports and charts using
BIRT in Design Studio.
This tutorial explains the following tasks:
-
Creating an interactive report (drill down)
- Preparing a drill-down report
- Creating parameters for the report
- Adding report parameters to the data set
- Creating a report layout
- Hiding columns on the report at runtime
- Creating hide parameter and adding hide image
- Enabling hiding of columns
- Adding pre-created styles and formatting
- Compound sorting
- Creating sort parameters and adding sort images
- Enabling compound sorting
- Adding report interactivity (drill through)
-
Using charts and grids together on a report
- Creating data set and computed columns
- Creating report layout
- Creating a sales report
- Selecting a chart
- Selecting the data
- Formatting the chart
- Creating Profit and Profit % charts
- Adding a grid to map the values of the chart
- Dynamically updating query to drive the charts and report
- Creating a template
- Using a template to create more reports
- Enabling interactivity
- Change data set and enable parameters
- Enable interactivity on the sections of charts
- Creating a drill-through report from department to sub-department
level
| | | |
