It's all about the answers!

Ask a question

BIRT: It seems that only time spent changes are not shown in the WORKITEM_CHNGS


Katrin Heymann (19823960) | asked Apr 16 '13, 3:24 a.m.
I'm creating a BIRT report based on WORKITEM_CHNGS.

To compare TIME_SPENT / PREV_TIME_SPENT entries I have created a report to show all WI changes.
There is a change in a workitem only in the time spent field. The report didn't show this change. A change in the summary and time spent field was shown.

Please can you help ?



Comments
Katrin Heymann commented Apr 16 '13, 5:06 a.m.

Are there any documentation which changes are reported in the WORKITEM_CHNGS ?

3 answers



permanent link
Sandy Grewal (1.6k1123) | answered Apr 16 '13, 11:58 a.m.
JAZZ DEVELOPER
@Katrin, the details can be found at: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

You can determine what changed by comparing the columns with their Prev_ equivalents (remembering that more than one thing may have changed).
The time_spent changes should be shown as per the documentation.

permanent link
ankur sharma (66212228) | answered Apr 16 '13, 12:02 p.m.
JAZZ DEVELOPER
1.Did you run the Data collection jobs after making the change?
2. I didn't understand this completely
"There is a change in a workitem only in the time spent field. The report didn't show this change. A change in the summary and time spent field was shown. "

The change in the time spent field was shown or not?

Comments
Katrin Heymann commented Apr 16 '13, 12:57 p.m.

Here our example:

Report Result:

Example1
Example2

History of WI 14233:

Only the latest change were shown in the report result.
 

Example3


Denis Maliarevich commented Dec 15 '14, 9:53 a.m.

> 1.Did you run the Data collection jobs after making the change?
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?

How can I run Data collection jobs manually?


permanent link
Katrin Heymann (19823960) | answered Apr 23 '13, 8:08 a.m.
Is it possible to compare Time Spent history entries with the existing Data Warehouse Snapshot Schemas ?

Your answer


Register or to post your answer.