It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,877

question asked: Mar 19 '13, 10:43 a.m.
question was seen: 4,060 times
last updated: Dec 16 '14, 5:29 a.m.

Related questions

Reporting the workitem change

0
Andrea Ianni (161●19●16) | asked Mar 19 '13, 10:43 a.m.
Hi all,
in RTC 2.0 I have a BIRT report to track the defects severity migration. I used the JDBC data source and queried "WORKITEMS_SNAPSHOT"."WORKITEM_CHNGS" table.

In few words, I would like a report that show if and how a defect change own severity in the time.

Using RTC4.0, where are stored this info?
I tried to use a Jazz Data Source and WORKITEM_CHNGS table but it's empty :(

Any ideas?
Thanks
Andrea

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Sandy Grewal (1.6k●12●23) | answered Apr 17 '13, 1:24 p.m.
JAZZ DEVELOPER
edited Apr 17 '13, 1:24 p.m.
@Andrea  https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20
WI severity is there.

One reason the table is empty is it has not been populated.
Check if you have run the ETL's to populate the tables.
Comments
Denis Maliarevich commented Dec 15 '14, 9:50 a.m.

Do you mean ETL jobs for RRDI reports?
Are there another group of "update jobs" to populate WORKITEM_CHNGS table?
We have problems with completing ETL jobs for RRDI DW, could it affect DW for Birt reports?

sam detweiler commented Dec 15 '14, 11:20 a.m.

Yes, the data gets into the DW via the ETL jobs.  Some of the tables are 'optional' and the etl needs to be enabled for those tables too..

you need to see the RRDI ETL docs on how to do that

Denis Maliarevich commented Dec 16 '14, 5:29 a.m.

Thanks for a quick answer.
I'll check ETL jobs.

0
permanent link
Andrea Ianni (161●19●16) | answered Apr 24 '13, 10:01 a.m.
Hi Sandy,
I asked to IT team and they said that all data collection jobs are running.
The data collection jobs are: common, repository, APT, License, Work Item, Build and SCM. Are some jobs missing?

For completeness, I must say that we upgraded our Jazz Server from version 2.0.0.2 to 3.0 and, after to 4.0.
Can this make any difference?

Thanks in advance

Your answer

Register or 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.