CODEWITHSUNDEEP
sql-serversql-server-2005ssascube
Raj More
Raj More

Reputation: 48016

DateTime in SSAS

I have a DateTime column in my Time dimension table. I want to display this as just MM/DD/YYYY and hide the time component (which is 00:00:00 anyways).

How do I do this?

Upvotes: 0

Views: 1461

Answers (1)

ajdams
ajdams

Reputation: 2314

Raj, I wouldn't alter this particular field because it may cause problems with ordering and calculations when browsing or pulling data from the deployed cube. What I would do is add another field to your time dimension say...SHORT_DATE and simply make it a varchar(10). I always keep at least one proper datetime in my [TIME] dimension for date dependant usage.

Upvotes: 1

Related Questions