It's all about the answers!

Ask a question

Missing Timeline in reports


Thomas Bollinger (4651) | asked Oct 12 '09, 9:30 a.m.
Hi,

Im experimenting with RTC and found something strange: When I want to display a report, Im redirected to the screen where to choose Timeline, Teamarea,... But neither of these has choises. I have 2 Projects (Both sampleprojects "Prelude" and "Junit", so they both have Timelines).

Im using 2 machines, one running RTC 2.0.0.1 Standard Edition as Server and another using RTC 2.0.0.1 Express-C as Client. At least on the the Server the reports should work.

What am I doin wrong?

Greetings,
Thomas

12 answers



permanent link
Rafik Jaouani (5.0k16) | answered Oct 13 '09, 2:04 p.m.
JAZZ DEVELOPER
The report parameter values will only show up if there are work items that use them; this applies to timelines, team areas, categories, iterations....

In addition most of our reports are not live. So even if you create a work item that you associate with the particular timeline, you will need to wait until the next day for the data to be propagated to the RTC data warehouse.

permanent link
Thomas Bollinger (4651) | answered Oct 14 '09, 9:32 a.m.
Thanks, that did the trick.

But is there a way to automatically generate a Snapshot for the Data Warehouse every day, or can the Snapshots only be generated manually?

Greetings,
Thomas

permanent link
Rafik Jaouani (5.0k16) | answered Oct 14 '09, 5:20 p.m.
JAZZ DEVELOPER
We advice against running the snapshots manually. The work items snapshot for example can insert thousands of records in one run.

For reports that really need to display the latest data, we usually design those to use data from both the data warehouse and the latest from the repository. The Burndown and Burnup reports are such reports. But such reports tend to be slower since they do not use any caching of data. So we try to avoid those, unless a customer insists for such functionality.

permanent link
Thomas Bollinger (4651) | answered Oct 15 '09, 2:47 a.m.
But how to make the snapshots automatically?

permanent link
Rafik Jaouani (5.0k16) | answered Oct 15 '09, 6:18 p.m.
JAZZ DEVELOPER
I am not sure I understand the question. RTC has a data warehouse that gets updated every midnight. So most reports will show data that could be at most 24 hours old.

Some reports like Burndown and Burnup collect data from both the data warehouse and the live repository so they always show up to date data. Such reports tend to be slower.

permanent link
Thomas Bollinger (4651) | answered Oct 16 '09, 5:20 a.m.
I just wondered why I couldnt create reports. I had workitems, Iterations, Timelines and everything since two weeks. And if all is updated daily I wondered why I still couldnt create the reports.

Now with your advices I have the reports working, but still dont understand how the Jazz-DataWarehouse works.

I hope I can figure it out myself if now everything is working.

permanent link
James Moody (3.3k24) | answered Oct 16 '09, 9:10 a.m.
JAZZ DEVELOPER
On 10/15/2009 2:52 AM, BigBo wrote:
But how to run the snapshots automatically?


The snapshots run automatically. The default time between runs is 24
hours, and we run them at midnight (server time). You can change the
time between runs on the server admin properties page in the web UI.

james
RTC Reports Team Lead

permanent link
James Moody (3.3k24) | answered Oct 16 '09, 10:26 a.m.
JAZZ DEVELOPER
On 10/16/2009 5:23 AM, BigBo wrote:
I just wondered why I couldnt create reports. I had workitems,
Iterations, Timelines and everything since two weeks. And if all is
updated daily I wondered why I still couldnt create the reports.

Now with your advices I have the reports working, but still dont
understand how the Jazz-DataWarehouse works.

I hope I can figure it out myself if now everything is working.


There is some technical documentation on the data warehouse in the
articles on our wiki:

https://jazz.net/wiki/bin/view/Main/ReportsMain

As well as a short paragraph in the overview:

https://jazz.net/projects/rational-team-concert/features/report

Basically, the data warehouse (properly, the "data mart") is a database
which is populated periodically (by the tasks we mentioned) by
collecting information from the Jazz repository and, in some cases,
performing aggregation on the data or otherwise manipulating it to be
more suitable to our reporting needs. If you have any specific questions
about how we collect the data or how the tasks work, I'd be happy to
answer them.

james
RTC Reports Team Lead

permanent link
Thomas Bollinger (4651) | answered Oct 19 '09, 3:45 a.m.
The snapshots run automatically. The default time between runs is 24
hours, and we run them at midnight (server time).

Ah now I see what was the problem. As my PC is switched off when Im not at work, the server couldnt make his snapshots at midnight.

Did I understand that correctly, that the data warehouse/mart hadnt any data just because the snapshots did run to a time the server was not running?

permanent link
Thomas Bollinger (4651) | answered Oct 19 '09, 3:49 a.m.
The snapshots run automatically. The default time between runs is 24
hours, and we run them at midnight (server time).

Ah now I see what was the problem. As my PC is switched off when Im not at work, the server couldnt make his snapshots at midnight.

Did I understand that correctly, that the data warehouse/mart hadnt any data just because the snapshots did run to a time the server was not running?

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.