How do change the Server Time Dimension date format in SQL 2005?

it is defaulting to [Time].[Date].&[1990-01-09T00:00:00]

I would like it to be formatted a MM/dd/yyyy: [Time].[Date].&[01/09/1990]

if your column type is a date time, then the key is the complete date time.
but you can use a different column for the name you want to display.
this column could be a calculated column which format the date to your
needs.

look at the sample provided in AS2005, I think you'll found how to do this
in the time dimension.


"Steven" <stevenheinz57 (AT) hotmail (DOT) com> wrote