dimension question

I'm creating a datawarehouse and I have a question on a date dimension. My
users want to see the date formatted as such yyyy-mm-dd so they can sort on
it. How can something like this be possible? I never did this so I'm new to
the datawarehouse - cubes - dimension things.On 15.03.2007 14:00, John wrote:
> I'm creating a datawarehouse and I have a question on a date dimension. My
> users want to see the date formatted as such yyyy-mm-dd so they can sort o
n
> it. How can something like this be possible? I never did this so I'm new t
o
> the datawarehouse - cubes - dimension things.
This is not really DWH specific. Normally output formatting is client
work. You could add a calculated column or create a view that does the
conversion of a timestamp to a particular time format.
robert