It's all about the answers!

Ask a question

Update of Datawarehouse tables


Ana Lopez-Mancisidor (25648967) | asked Feb 23 '10, 5:23 a.m.
JAZZ DEVELOPER
Hi,

Can I configure the update of all datawarehouse tables to be done
automatically every day at night, or every 4 hours for example? I have
not seen this Admin configuration option and only option I have seen is
to update manually the datawarehouse going to the Reports link.

Do I have to manually update every project area or the update in one
project area also updates others? This can be very time consuming if
automatic updates can not be programmed and I have a project area per
application.

Thanks,

Ana

3 answers



permanent link
James Moody (3.3k24) | answered Feb 23 '10, 12:53 p.m.
JAZZ DEVELOPER
On 2/23/2010 5:15 AM, ana.lopez wrote:
Hi,

Can I configure the update of all datawarehouse tables to be done
automatically every day at night, or every 4 hours for example? I have
not seen this Admin configuration option and only option I have seen is
to update manually the datawarehouse going to the Reports link.

Do I have to manually update every project area or the update in one
project area also updates others? This can be very time consuming if
automatic updates can not be programmed and I have a project area per
application.

Thanks,

Ana


You can configure the delay between runs (e.g. every 4 hours) but other
than midnight, which is a magic case, you can't specify *when* the run
will happen. (I.e. you can't schedule it for 4am). The property is in
the server admin page, in Advanced Properties, and is called "Data
Warehouse Snapshot Time". The value is a long, indicating milliseonds
between runs.

james
RTC Reports Team Lead

permanent link
Ana Lopez-Mancisidor (25648967) | answered Mar 01 '10, 3:53 a.m.
JAZZ DEVELOPER
On 2/23/2010 6:52 PM, James Moody wrote:
On 2/23/2010 5:15 AM, ana.lopez wrote:
Hi,

Can I configure the update of all datawarehouse tables to be done
automatically every day at night, or every 4 hours for example? I have
not seen this Admin configuration option and only option I have seen is
to update manually the datawarehouse going to the Reports link.

Do I have to manually update every project area or the update in one
project area also updates others? This can be very time consuming if
automatic updates can not be programmed and I have a project area per
application.

Thanks,

Ana


You can configure the delay between runs (e.g. every 4 hours) but other
than midnight, which is a magic case, you can't specify *when* the run
will happen. (I.e. you can't schedule it for 4am). The property is in
the server admin page, in Advanced Properties, and is called "Data
Warehouse Snapshot Time". The value is a long, indicating milliseonds
between runs.

james
RTC Reports Team Lead

Hi,


So if I change this value to 6 for example, does this mean that the
datawarehouse update service will update 4 times each day automatically?
At 01.00 AM, 06.00 AM, 01.00 PM and 6.00 PM.

Thanks,

Ana

permanent link
Rafik Jaouani (5.0k16) | answered Mar 01 '10, 9:32 p.m.
JAZZ DEVELOPER
The "Data Warehouse Snapshot Time" property allows you to choose a value between 1 and 24 (hours). All the scheduled daily snapshots will run at the chosen hour.

The "Data Warehouse Snapshot Time" property only affects snapshots whose "Task Delay" value is 86400 (24 hours).

I highly advice against changing the "Task Delay" property. Running the "Workitems Snapshot" every 4 hours will increase the size of your data warehouse significantly.

Some of our out of the box reports like Burndown and Burnup show a last live point which gives you up to the second up to date data.

Most report could be made to behave that way (by enhancing the report template). Of course this has the drawback of making those reports non-cacheable and they may run slower.

The current default setup which we have been using on jazz.net seems to offer the best compromise between performance and usability.

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.