RRDI Reporting - Live Data from RTC/RQM/RRC

 Hi Benjamin,

Hello VK L,

regarding the other tools that you can use for live reports:
- BIRT is OK but supported for RTC only
- RPE (Rational Publishing Engine) can be an option for all the CLM applications

Best Regards,

Francesco Chiossi

Sorry for the delay in getting back.  It would be possible to create a similar model for RTC and RDNG, however the work involved would be quite a bit.  It's not a matter of querying the live RTC/RRC database tables, but rather using the Rational XML JDBC driver that maps REST requests to relational XML, and then developing a Framework Manager data model that queries against those virtual mapping tables to get the data in to a report.  After all is said and done, you end up with a solution that puts heavy load on the system and is not optimal for anything more than basic reports.  So while technically possible, I would strongly advise against it.  You can use the new Data Collection Component (DCC) to run more frequent ETL's throughout the day so that your data is as close to real-time as you'd like.  Then you can either use the traditional DW reporting model from RRDI, or use the Jazz Reporting Service (JRS) to create reports across the lifecycle.  Hope it helps,

 Thanks Abhinav. But as with report formatting, export-options, and a custom-designed tables,charts,etc Does Birt have advanced facilities to support equivalent to cognos?

Hi VK L

Does Birt have advanced facilities to support equivalent to cognos? -- Not Sure    as never got a chance to work on Cognos

Many Thanks