On 2/20/2010 3:54 PM, ana.lopez wrote:
Hi,

I would like to create a line type chart to show the evolution of number
Hi, I have been doing some tests and yes, the history is stored. My
problem was that all changes performed during the same day (although I
updated the datawarehouse several times during the day) are stored with
the same hour 1.00 AM. But history of changes are stored.

Thanks,


of files added to a particular component during last week.


Although I am able to create that graph all FILE_ADDITION_COUNT values
are just for the last day I updated all snapshot data in the
datawarehouse but it does not store history of previous values. It seems
that the datawerehouse only stores values for last update and older
values in tables taken in previous days are deleted.

Is this true? Is there any way to create this reports accessing to other
data?

Thanks,

ana

On 2/22/2010 8:00 PM, James Moody wrote:
On 2/20/2010 7:49 PM, ana.lopez wrote:
On 2/20/2010 3:54 PM, ana.lopez wrote:
Hi,

I would like to create a line type chart to show the evolution of
number
Hi, I have been doing some tests and yes, the history is stored. My
problem was that all changes performed during the same day (although I
updated the datawarehouse several times during the day) are stored with
the same hour 1.00 AM. But history of changes are stored.

Thanks,


of files added to a particular component during last week.


Although I am able to create that graph all FILE_ADDITION_COUNT values


are just for the last day I updated all snapshot data in the
datawarehouse but it does not store history of previous values. It
seems
that the datawerehouse only stores values for last update and older
values in tables taken in previous days are deleted.

Is this true? Is there any way to create this reports accessing to
other
data?

Thanks,

ana


The SCM data is expensive to compute and store - the data is aggregated
by day when the snapshots run (usually in the middle of the night).

james
RTC Reports Team Lead


Hi James, many thanks for your quick response. I understand that
aggregating SCM data can consume a lot of resources and should be done
only when users are not working.

But my main concern is that the timestamp values (or additional column
data related with month, day...) should represent the real values when
change sets were created or delivered to streams in RTC. Otherwise the
reports may not represent real values if snapshots are not taken
frequently (i.e, although change sets may have been delivered February
22 if the snapshots do not run during February 21 the report looks like
if I had not delivered anything to the stream that day but it was
delivered).

I.e, a report that shows the amount of change sets delivered to each
streams are critical for continuous integration metrics and although I
am able to create it with BIRT the values depend if I create or not
snapshots each day.

Thanks again,

Ana