Limitations with using System Date part 1

Tuesday, January 27th, 2009

Often in a reporting or data analysis scenario the analyst or business user wants to view data that is current, for example, sales for the current week or employee turnover for the current month etc. The analyst could create the report and then just enter whatever the current date is ...

Limitations with using System Date part 2

Monday, January 26th, 2009

In the previous article we looked at why using System Date functions in a BI solution can lead to difficulties in development and testing. In this article we are going to look at several alternatives to using system date functions.

Limitations with using System Date part 3

Sunday, January 25th, 2009

In the last article we looked at alternatives to returning the system date in the report queries. This article looks at the report and alternatives to using system date functions in report calculations