Update of Datawarehouse tables
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
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
On 2/23/2010 5:15 AM, ana.lopez wrote:
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,
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
On 2/23/2010 6:52 PM, James Moody wrote:
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
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
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.
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.