Time doesn't stand still. Tomorrow, today will be
yesterday. This is not only a play on words; it is also a
reality that radically complicates reporting on data.
When you report on time based data, the value of any particular
point in time needs to be categorized not only by the date on which
it cocurred, but in reference to the date the reprot is being
This presentation provides you with straight forward query
techniques to categorize time based data, from the perspective of
another point in time. It will demonstrate how to use a
rolling window methodology to easily preent different time ranges
and periods using a single report definition.
The end result is the ability to use a single query replacing
dozens of procedures, a reduction in report definitions, reduction
of data storage and enhanced performance.
March 18, 2015 - Session 2
created using: engage CMS