DWH & CCM DB Schemas
Our company uses RTC. I want to create SQL queries to read RTC data from DB directly. I've already created a lot of queries. And all of them select data from DHW schema. ... But now I have a problem.
Business Need work item has customized field “Target Release” in our RTC system. The field allows to select one of iterations. I’ve found values of this field in “model”.”work_item_item_extensions” table of CCM schema and I’ve not found this field in DWH schema which I use for queries.
|
One answer
Hi Valery,
I think the following document may help you: http://www.ibm.com/developerworks/rational/library/add-a-rational-team-concert-data-warehouse-extension-for-custom-attributes/index.html Regards, John Comments
Valery Serogodsky
commented Aug 23 '13, 8:56 a.m.
Thank you John! I will look in the document. I've looked in the document. It was very interesting. Now I know how custom attributes are stored better. But my question still exists ...
Values of “Target Release” custom attribute are stored CCM schema (“model”.”work_item_item_extensions” table). I found them. It's clear for me.
|
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.