As my company is going international, I'm looking to expand my 2005
cubes' datetime dimension to incorporate different time zones. Has
anyone successfully implemented attributes in a single datetime dim
that will span different timezones (along with useful aggs)? Or, has
any one done this succinctly using mutliple dims? I'm concerned about
dimension member/data/cube size explosion in tackling this problem and
appreciate any insight. Similar to what Microsoft did for currency
conversion, I hope that at some point they will put in special AS
functionality to handle this.

thanks!

This entry in Chris Webb's blog might give you some ideas:

http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!367.entry
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***