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

Data warehouse extension - BIRT reporting

Questions
Tags
Users
Badges
Zachary K
(193●5●43●39) edited
Feb 12 '13, 4:48 p.m.
Hello,
I'd like to do something similar to what is described is this article http://www.ibm.com/developerworks/rational/library/add-a-rational-team-concert-data-warehouse-extension-for-custom-attributes/index.html

I have BIRT reports that use lots of custom attributes and it starts to impact performances. The Jazz data source is LIVE_SNAPSHOT and I use the table com.ibm.team.workitem.WorkItem to generate the reports as I need access to itemExtensions.key and stringExtensions.key.
My question is; can I use the data warehouse extension point for this data source?
Thanks for your help.

0 votes

1 answer
5,838 views
0 votes

One answer

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Feb 12 '13, 5:19 p.m.

I would really advice against extending the data warehouse the way the article describes. The article was based on version 2.0 of RTC and it covers the legacy datamart which has been replaced since 3.0.1 with the data warehouse. We are currently targetting the following enhancement request to 4.0.3:

[CCM] Make complex custom work item attributes, approval descriptors and Modified By data reportable and available in the data warehouse (242806)

Once the above is implemented, the data will be available to RRDI reporting.

1 vote

Comments
Zachary K
May 09 '13, 11:43 a.m.

Thanks for the heads-up. 

What can I do in the meantime to speed things up in BIRT reporting with RTC 4.0.1 when one uses many custom attributes. Do you have any recommendations?
Thanks in advance for your help.

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
× 324
× 26

Question asked: Feb 12 '13, 4:46 p.m.

Question was seen: 5,838 times

Last updated: May 09 '13, 11:43 a.m.

Confirmation Cancel Confirm