October 29, 2010 at 12:17 am
I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC time and use system generated Time dimension in the cube.
Up until recently the granularity of a day was just fine for our needs.
Now ( I've been doing SSAS for just a month), I've been asked to redesign DateTime dimension so it allows for different time zones, as we need to send out reports to users in different time zones. I just need to have EST, PST and UTC time zones with no DayTime Savings adjustments.
I'm not able to find a solution on the web...
any suggestions are welcome.
October 29, 2010 at 7:54 am
Do you have a Location Dimension which is linked into your fact table?
If so, then I'd add the offset values in hours from your 'base' location / time zone in there. Otherwise, I'd set one up. Another possibility would be to have the Base TimeId linked to your TimeDim and another column with TimeIDLocal also linked into your TimeDim and set this as part of the load based on location/timeZone.
hth
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply