timesheet with BIRT Report
I tried to create a time-sheet using BIRT report. The idea was basically to create a list of all changes in the "time-spent"-attribute listing the date, the owner and the work item and the amount of the change.
I used the WORKITEM_CHNGS table in my Data Set where I basically had all the columns needed. But somehow I only get strange results, my report does not take into account all results, even if I leave out filters like "time-spent">"Previous time-spent". I tought from the description of the schema, I would have a full account of all changes in work items in this table. What am I doing wrong? Thanks Marco |
9 answers
|
Solved the problem myself: After an update of the WORKITEM_SNAPSHOT everything works fine.
|
Solved the problem myself: After an update of the WORKITEM_SNAPSHOT everything works fine. Hello Marco, I am trying to do this myself, but I have not yet managed! In order to get the result you wanted, did you create a simple Work Item query, or did you create a new report? Please could you share this information with me? I would find it very useful! Thank you and best regards, Andrew |
|
Hello Andrew,
I created a new Report, without using a query. There are a lot of tools in the Report Data Set Wizard to Filter and Configure the data I needed. In my case we just wanted to know who worked which day on which task for how long. A the data to do this seems to be there, one I had found the update button. But I still have some trouble with the database schema, at times there are things I cannot find. Solved the problem myself: After an update of the WORKITEM_SNAPSHOT everything works fine. Hello Marco, I am trying to do this myself, but I have not yet managed! In order to get the result you wanted, did you create a simple Work Item query, or did you create a new report? Please could you share this information with me? I would find it very useful! Thank you and best regards, Andrew |
Hello Andrew, Hello Marco, I managed to leverage the BIRT functionality to create a similar report and the first thing I noticed is that there is a delay between the time a work item is modified and the time it becomes visible in the report. Also, if the same user modifies the "Time Spent" attribute more than once, only one record appears in the report rather than a record for each modification. Have you managed to solve this issue? Regards, Andrew |
|
Hello Andrew,
I do have the same issues but I do not see them as a huge problem. Updating the database before getting a report is surely a little tiresome but it can be done and I even prefer to have the records for a single user and a single work item summed up. Regards, Marco
|
Hello Andrew, Hello Marco, Thank you for the info. Last info: how do I update the database to render work item changes visible? Regards, Andrew |
|
In the web-interface, go to "reports", which will appear if you select a project area, then "administer data warehouse" and there are some update buttons. It will probably take some seconds to execute.
Hello Andrew, Hello Marco, Thank you for the info. Last info: how do I update the database to render work item changes visible? Regards, Andrew |
On 6/22/2010 5:23 AM, MarcoB wrote:
In the web-interface, go to "reports", which will appear if The following resource might help you when authoring reports; it's an annotated description of each of the tables and columns in the data mart: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 james RTC Reports Team Lead |
Geoffrey Clemm (30.1k●3●30●35)
| answered Jun 26 '10, 10:47 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
One of the tables referenced in:
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 is the "Live Snapshot" view. Where would we find documents that describe the tables provided by the various components to this view? In particular, it would be ideal if references to these documents could be added to the DataWarehouseSnapshotSchemas20 page! Cheers, Geoff On 6/25/2010 1:29 PM, James Moody wrote: On 6/22/2010 5:23 AM, MarcoB wrote: |
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.