time dimension | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

time dimension

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.

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.
thanks a lot
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |