Get started with the Rational Reporting tool for Collaborative Lifecycle Management

Configure RRDI, Rational Reporting for Development Intelligence, to work with CLM applications and reports

This guide for deployment of Version 2.0 of the Rational Reporting for Development Intelligence (RRDI) also explains how to integrate RRDI with the Collaborative Lifecycle Management (CLM) 4.0 data warehouse. You can then generate reports for Rational Team Concert, Rational Quality Manager, and Rational Requirements Composer.

Share:

Murali Dhandapani (muralindia@in.ibm.com), IT Specialist, IBM China

author photoMurali Dhandapani is part of the ISL Operations Software Engineering Service team at IBM Software Labs, in India. He is an IBM Certified IT Specialist in System Management and a technical lead for Rational Jazz-based products infrastructure deployment. He is a contributing author for developer works.


developerWorks Contributing author
        level

Sonali Samantaray (sonali.samantaray@in.ibm.com), Senior Staff Software Engineer, IBM

Photo: Sonali SamantaraySonali Samantaray works as a Senior Staff Software Engineer for IBM Software Labs, India for the WebSphere group. Along with a Master in Computer Applications degree, Sonali is an IBM Certified DB2 Associate and IBM Certified SOA Associate also. She has authored various technical documents for the product and for various symposiums. She is a contributing author for developerWorks.


developerWorks Professional author
        level

Arul Doraisamy (adoraisa@in.ibm.com), IT Specialist, IBM

author photoArul Doraisamy works for Software Engineering Services Team in India Software Lab (ISL), India. Currently leading the team on Rational tools deployment and Administration for ISL projects. He has a Master degree of Computer Science and IBM Certified ClearQuest Administrator.



02 October 2012

Also available in Portuguese

IBM Rational® Reporting for Development Intelligence, Version 2, (also called RRDI) is the reporting tool for the Rational solution for Collaborative Lifecycle Management, Version 4.0 (CLM 4.). This article provides instructions for deploying RRDI 2.0 on an IBM® AIX® operating system and integrating with the CLM 4.0 data warehouse IBM® DB2® database server for IBM Rational Team Concert™, Rational® Quality Manager, and Rational® Requirements Composer to generate reports by using sample report definitions from the respective applications.

Review the setup architecture

The diagram in Figure 1 shows the setup used as the basis for this article. Here. RRDI is deployed on AIX. It also supports Microsoft Windows, Linux, and IBM® System z® platforms. Download the appropriate RRDI package for your setup. See Resources for the link to "System Requirements for Rational Reporting for Development Intelligence 2.0," which provides the list of supported hardware and software details.

Prerequisites:
This article is based on the assumption that the CLM 4.0 server is already installed and configured, along with database.

Figure 1. RRDI and CLM setup
Flow diagram of the setup

Set up data storage

Install IBM DB2 and create a database instance.

  1. While running the Rational Reporting setup:
    1. Create a content store database that uses this instance.
    2. Create the DB2 catalog to locally mount the database (data warehouse) of CLM 4.0 on the RRDI 2.0 server.

Important:This is mandatory when you have RRDI on one server and CLM data warehouse on another server. The IBM® Cognos® data source connection for RRDI and DB2 connection string will use localhost.

The following commands help in creating a DB2 catalog on the AIX server:

su – db2instl

db2 catalog tcpip node <nodeName> remote <Remote IP Address> server <port number> 

db2 catalog database DW at node <nodeName> 

db2 list node directory 

db2 connect to DW user db2inst1 using <password>

To grant database administration privileges for rptuser, use the following command:

db2 grant dbadm on database to user rptuser
  1. After creating the database instance and configuring the catalog for connecting to the remote data warehouse, exit from db2inst1.
  2. Then execute the db2profile and set LIBPATH:
source /home/db2inst1/sqllib/db2profile

On an IBM® AIX® system, the default library path is 64-bit, but a 32-bit library path is mandatory to complete the Rational Reporting setup successfully.

  1. Ensure that the 32 bit libraries are installed and export the LIBPATH:
export LIBPATH=$LIBPATH:/home/db2inst1/sqllib/lib32
  1. Verify the library path by using this command:
echo $LIBPATH

Note:
The remote IP address used while creating the DB2 catalog is the IP address of the CLM 4.0 server with the data warehouse configured. See the "Cataloging a database" citation in the Resources section for details.

Deploy Rational Reporting for Development Intelligence The deployment of Rational Reporting for Development Intelligence (RRDI 2.0) involves three stages:

  • Installation of RRDI 2.0
  • Setup of Rational Reporting
  • Post-setup tasks

Successful installation of RRDI 2.0 on AIX will provide the details to run the Rational Reporting setup. RRDI 2.0 is bundled with the Apache Tomcat server, which helps to run the Rational Reporting setup.

  1. Before proceeding with the Rational Reporting setup, start the Tomcat server from the RRDI 2.0 installed path:
cd /opt/IBM/RRDI2/setup/tool/JazzTeamServer/server ./server.startup
  1. Now click Set up Rational Reporting and configure RRDI, using the RRDI setup link:
    https://islswestest5.in.ibm.com:10443/rrdi/setup.

Note:
AIX is the operating system that we used for the deployment while writing this article. If you are working on an AIX system, ensure that the /tmp partition has at least 200 MB space. While preparing the setup for the article, /tmp had 1 GB. See the"Installing Rational Reporting for Development Intelligence" citation in Resources, for the details.


Set up Rational Reporting for Development Intelligence

  1. Using the RRDI setup link, configure the content store, data warehouse, IBM® WebSphere® Application Server, and report server.

Build and Deploy Reporting Components is the last step while running the Rational Reporting setup. It takes care of the report server configuration. This step usually fails if the 32-bit library is not set properly, as explained previously. Figure 2 indicates the successful completion of deploying the reporting components.

Figure 2. Build and deploy components
successful status of reporting components
  1. Click Next to see the summary shown in Figure 3.
  2. Click Finish to return to the RRDI setup page.
Figure 3. Summary page for the Rational Reporting setup
summary for each setup component
  1. Click Run post-setup tasks to complete Jazz™ namespace configuration and load Cognos archives. Figure 4 shows the summary of post-setup tasks.
Figure 4. Summary of post-setup tasks
displays post setup tasks summary

This enables sample report definitions in the public folder on Rational Reporting (see Figure 5) for Rational Team Concert (the change and configuration management software, or CCM), Rational Quality Manager (quality management, or QM), and Rational Requirements Composer (requirements management, or RM). Each folder contains the relevant data warehouse reports.

Figure 5. Sample Report Definitions
displays sample report definitions

Note:
See the "Post-installation tasks" link in Resources for the details.


Verify the data source connection

  1. To verify the data source connection, log in to RRDI 2.0 at http://islswestest5.in.ibm.com:11080/reporting, and click IBM Cognos administration.
  2. Then open the Configuration tab, select RIDW > more > Test the connection, and click Test, as shown in Figure 6.
Figure 6. Test data source connections
Test the connection - RIDW view

If the connection works, the Status column in the results will show Succeeded, as shown in Figure 7.

Figure 7. Connection test results
Name, Type, status

Configure the Collaborative Lifecycle Management data warehouse

The data warehouse component in the server's Advanced properties of Collaborative Lifecycle Management is used to configure the data collection user and data warehouse snapshot time, which is nothing but scheduling the job run time and XDC authentication type (see Figure 8). This takes care of the Jazz Team Server and Rational Requirements Composer data collection jobs. For change and configuration management (CCM) and quality management (QM), the application's Advanced properties contain the data warehouse component. Configuration for all of these components should be similar. The data collection user should have a Data Collector license.

Figure 8. Data warehouse component configuration
connection settings for property and current value

Note:
The CLM 4.0 server is configured with LDAP authentication, and the data collection user specified here is one of the LDAP users who has a Data Collector license.


Schedule data collection jobs

Proper settings in the data warehouse component configuration for Collaborative Lifecycle Management ensures that the data collection jobs are running fine, as shown in Figure 9. Here, the Job Scheduling value is set to run once in 12 hours by specifying the value as 12, and Job History reveals the same in Figure 10.

Figure 9. Data collection job schedule
Job schedule display
Figure 10. Data collection job status
Job history display

Explore sample data warehouse reports After successfully configuring the data warehouse components on Collaborative Lifecycle Management, log in to Rational Reporting for Development Intelligence (RRDI 2.0).

Then you can generate reports for change and configuration management (CCM), quality management (QM), and requirements management (RM) by using the sample report definitions.

These reflect the real-time date of the respective project areas, according to the latest data collection jobs successfully executed.

Figure 11 shows the list of date warehouse reports for CCM that are included in RRDI 2.0. There are also many data warehouse reports included for QM and RM.

Figure 11. List of data warehouse reports available for CCM
list of reports under the Public Folders tab

Figure 12 shows one of the sample reports generated by using the "Development items implementing or impacting Requirements" date warehouse report.

Figure 12. Sample report
sample change management report

Summary

This article explained deploying Rational Reporting for Development Intelligence (RRDI) Version 2.0 and integrating it with the Collaborative Lifecycle Management (CLM) Version 4.0 data warehouse on an IBM AIX operating system. It also provided details about generating reports by using data warehouse reports for Rational Team Concert, Rational Quality Manager, and Rational Requirements Composer, which are all involved in CLM.

Resources

Learn

Get products and technologies

  • Download a free trial version of Rational software.
  • Evaluate other IBM software in the way that suits you best: Download it for a trial, try it online, use it in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement service-oriented architecture efficiently.

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

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

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



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.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

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

 


All information submitted is secure.

Dig deeper into Rational software on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Rational, DevOps
ArticleID=837693
ArticleTitle=Get started with the Rational Reporting tool for Collaborative Lifecycle Management
publish-date=10022012