It's all about the answers!

Ask a question

BIRT Usage by User Report


Rick Crosby (111) | asked Jun 24 '15, 11:58 a.m.
Trying to write a RTC BIRT report to get update stats on Work Items by user.

Managed to extract the Updates by using 
Data source - WORKITEMS_SNAPSHOT
Table - WORKITEM_CHNGS

This table appears  to contain all the updates to WorkItems, but the attribute CONTRIBUTOR_NAME refers to the owner of the Work Item and not the user performing the update. I cannot find anywhere how to get details of the user that is actually performing an update.

The only detailed schema reference for the Datawarehouse Snapshots I can find is
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20
But this is for V2 of RTC and we are currently running 5.02

Anyone know where I can find this information or details of the snapshot schemas for V5.02?

Thanks


Be the first one to answer this question!


Register or to post your answer.