Hello,
I've been having an issue trying to display anything other then a Long Date in Analysis Services. I've used the Server based Time Dimension and I've also tried creating a dimension for a User Created Date Table.
It seems no matter what I do the date attribute always displays as a long date.
Any Ideas?
If you need more flexibility (and most applications), what I typically recommend is to create a standalone time dimension table. For example, if you look at Project REAL, we use surrogate keys for all of our dimensions except time -- and for it we use YYYYMMDD as an integer. And use it as the surrogate key between the fact tables and a standalone time dimension.
See http://www.microsoft.com/sql/bi/ProjectREAL
_-_-_
No comments:
Post a Comment