none
Date Formats In Analysis Services 2005 RRS feed

  • Question

  • 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?

    Wednesday, February 1, 2006 5:57 PM

Answers

  • 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

    _-_-_

     

    Wednesday, February 1, 2006 10:54 PM