|
Shawn-
In a consulting project recently we faced the same question. The answer we arrived at was to convert everything to the time zone where the data warehouse resided and then built reporting filters at the remote locations to convert to their local time.
I'm sure there are other answers but this process worked for us.
Good Luck!
|