birt reporting cross-discipline reporting across rational repositories bill nelson
TRANSCRIPT
![Page 1: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/1.jpg)
BIRT ReportingCross-discipline reporting across Rational repositories
Bill Nelson
![Page 2: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/2.jpg)
2
What is BIRT?
> Business Intelligence and Report Tools Project
> Open source initiative as part of the Eclipse Foundation
> Initially focused on embedded reporting for Java Developers
> Similar to “Crystal Reports” but free
> Rational integrating into their products (v7.1)
> Next generation reporting technology
> Eclipse-based Report Designer> Web-centric design metaphor> Open Source with rapid adoption> Standards based & highly
extensible> Open XML design format> Build community and ecosystem
Project Goals
![Page 3: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/3.jpg)
3
What problem are we trying to solve?> Abstract “tool” information to a level to be digested
by management/executives
> Required reporting across different tools (e.g. ReqPro, ClearQuest, Test Manager) and repositories
> Required easy accessibility (e.g. web) that was on-demand
> Required “customization” to fit language of BCBSMN
> Hope is that it will result in better adoption of tools
![Page 4: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/4.jpg)
4
Why do we use BIRT?> Needed a way to report across Rational repositories and make easily
accessible and relevant to management/executives> Open source (free) and deployment to WebSphere (Web application)> Rational is replacing Crystal Reports with BIRT in ClearQuest v7.1> Powerful and relatively simple
![Page 5: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/5.jpg)
5
How are we using BIRT?
Oracle Schemas(ReqPro)
BIRT Eclipse Client
Management /Executive
Oracle Schemas(ClearQuest)
DB2 Databases(Test Manager)
ClearCaseRepository
Browser
Websphere 6.1BIRT Runtime Engine
BIRT R
epor
t File
(XM
L)Deploy BIRT Report
XML File
HTML
JDB
C
JDB
C JDBC
Export to P
DF,
Word, E
xcel
BIRT Author
Rational ToolsetIT Worker Bee
![Page 6: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/6.jpg)
6
Example – Test Execution Summary
![Page 7: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/7.jpg)
7
Example – Test Execution Detail
![Page 8: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/8.jpg)
8
Example – Requirement Validation Matrix Summary
![Page 9: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/9.jpg)
9
Example – Requirement Validation Matrix Detail
![Page 10: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/10.jpg)
10
Example – Defect Summary
![Page 11: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/11.jpg)
11
How will we measure success?
> Project measurement processes do not allow for a detailed measurement plan
> Case studies powered by “educated” estimates of key project personnel
![Page 12: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/12.jpg)
12
Demo – Create simple report
> Show integration with ClearCase
> Connect to Database
> Create Datasets
> Create Table
> Preview
> Hyperlink to detail table
![Page 13: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/13.jpg)
13
Next Steps - Dashboard
> Ours is bad today
![Page 14: BIRT Reporting Cross-discipline reporting across Rational repositories Bill Nelson](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa71a28abf838c98bd0/html5/thumbnails/14.jpg)
14
Next Steps – CQTM/CQ Enterprise Migration and Oracle Views
Oracle Schemas(ReqPro)
BIRT Eclipse Client
Management /Executive
Oracle Schema(ClearQuest)
ClearCaseRepository
Browser
Websphere 6.1BIRT Runtime Engine
BIRT R
epor
t File
(XM
L)Deploy BIRT Report
XML File
HTML
JDB
C
Export to P
DF,
Word, E
xcel
BIRT Author
Rational ToolsetIT Worker Bee
Oracle Views