Missing Timeline in reports

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.

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

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.

But how to make the snapshots automatically?

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.

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.

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

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

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?

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?