Hi everyone,
A couple of my T-Stats users mentioned that they wanted our T-Stats weeks to run from Monday-Sunday instead of Sunday-Saturday. I figured this would be an easy fix, and determined from T-Stats documentation that the @load_datefirst parameter in load_warehouse can be changed for this adjustment, and for a Monday start, should be set to 1.
But in our load_warehouse procedure, @load_datefirst is already set to 1. However, in T-Stats, all measures or dimensions that list out day of week or organize by day of week still list Sunday first.
What exactly does the parameter adjust? Does this need to be set anywhere else? Am I seeing something buggy?
Thanks,
frannie
...And I fixed my own problem. The parameter was set to 1 in the SP but it was set to 7 (Sunday) in the Job Schedule.
thanks,
But while I'm here! Now that I'd like to change this, I see that a change could potentially break user reports. Does this mean re[ports utilizing a date parameter the reflects Day of Week would need rebuilding? I think we'd be ok with having to redo a couple of saved reports if it meant that they would be more accurate to our institution. But are there larger repurcussions? Has anyone done this?
Frannie