SQL Server Performance

time dimension

Discussion in 'SQL Server 2005 Analysis Services' started by elepag, Apr 19, 2007.

  1. elepag New Member

    I am creating a simple SAS 2005 Cube. One of the things I want is a time
    dimension with the hierarchy Year -> Quarter -> Month -> Date.

    This time dimension shuold relate to a datetime field in my fact table(yyyy/mm/dd).

    I am sure this is something simple, but I cannot find anywhere how to do
    this... I am still new at SAS2005, and this is the last thing keeping me
    from publishing my 1st Cube.


  2. satya Moderator

    SQL Server 2005 books online should help you to get more information, refer to HOW DO I topics under latest BOL in this regard. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlovr9/html/5a61d172-ad31-4f3d-b3a8-50dcc89c6ae0.htm &http://sqlserver-qa.net/blogs/tools/archive/2007/04/18/how-do-i.aspx links.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. elepag New Member

    thanks a lot

Share This Page