Missing Timeline in reports

The snapshots run on the server as the information is needs is all on the servrer - so as long as your PC is not the server too - the snapshots should have run.

And in my case, my PC is the server. Now I have it make the Snapshot just after lunch, and it seems to work (at least, I got actual reports today, half an hour after the new Snapshottime).

The simplest things can be the hardest... :-(

But thanks for all the advices, I think I got it.

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?

Hi

The snapshots run on the server as the information is needs is all on the servrer - so as long as your PC is not the server too - the snapshots should have run.

Let's go back a step. Assuming you have not changed the default settings, a snapshot should run every night. Use the WebUI for all of the following...

You need admin access to change settings here:

https://jazz-server:9443/jazz/admin#action=com.ibm.team.repository.admin.configureAdvanced

(change the server:port name to your machine)

then look for the Data Warehouse section and edit the snapshot time. Default is midnight.

You can run a snapshot manually, go to your project, and select Reports. On the left-hand side, you should see an Admin section and select Administer Data Warehouse. You can click on Update All Snapshot Data.

Be a bit careful about this (as James pointed out) - if this was a production server and there was a lot of data - it could take a while to run.

Hope that helps

anthony

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?

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

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

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.

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.

But how to make the snapshots automatically?

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.