Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI Reporting - Live Data from RTC/RQM/RRC

Questions
Tags
Users
Badges
VK L
(817●7●157●159) edited
Oct 30 '14, 12:16 p.m.
 Hi All,
            Does RRDI support live reporting across all the CLM Applications? Also, is there any performance degrade in using live reporting instead of the normal warehouse one.

Please share some articles/blogs/links on this topic.

Thanks.

0 votes

2 answers
8,322 views
0 votes

2 answers

Permanent link
Benjamin Silverman
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (4.1k●6●10) Oct 30 '14, 12:30 p.m.
There is a live reporting data model for RQM only, however like you suggested it does put extra load on the server in order to extract the data.  See this topic for details.  I would suggest that if you do use the live model, limit your usage to basic reports that do not pull large amounts of data from the repository.  Let the data warehouse do the heavy lifting by using the data warehouse reporting data model.  Hope it helps,

2 votes

Comments
VK L
Nov 12 '14, 4:52 a.m.
 Hi Benjamin,                      I understand that RQM has an out-of-the-box live reporting model. Is it possible to create a similar live model for RTC say, using Framework manager tool - Are the live RTC/RRC tables exposed for this? Also, is Live RTC/RRC possible using BIRT or any other reporting tool - Are the direct tables available for data extraction? Thanks.

Francesco Chiossi
Nov 14 '14, 7:34 a.m.
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

1 vote

Benjamin Silverman
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 17 '14, 3:01 p.m.
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,

1 vote

Permanent link
Abhinav Mishra
(144●31●39) edited
Nov 18 '14, 3:52 a.m.
Hello VK L,
I think RRDI doesn't support reporting on Live Data of CLM. If you want to report live data from RTC then go for BIRT.


Thanks!


0 votes

Comments
VK L
Dec 05 '14, 6:39 a.m.
 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? From the past, i have seen that some querying capabilities are also not very straight-forward and does it have access to all the exposed data in RIDW?

1 vote

Abhinav Mishra
Jan 27 '15, 8:13 a.m.
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

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,147
× 485
× 403
× 3

Question asked: Oct 30 '14, 5:38 a.m.

Question was seen: 8,322 times

Last updated: Jan 27 '15, 8:13 a.m.

Confirmation Cancel Confirm