SSAS Articles 
Time Dimension How to create a time dimension in SQL Server 2005
Time Dimension How to create a time dimension in SQL Server 2005
| How to create a time dimension in SQL Server 2005 |
| Written by Thomas Ivarsson |
| Tuesday, 02 October 2007 07:08 |
|
How to create a time dimension in SQL Server 2005. A lot of posts in the SSAS2005 newsgroup have questions regarding how to construct a time dimension. In SSAS2005 you can generate a server time dimension but having control over this is much better and it is not that hard. Let’s start with creating a list of dates. Jamie Thomson (http://blogs.conchango.com/jamiethomson/rss.aspx) has a TSQL solution with a new feature in SQL Server 2005 called common table expressions or CTE: s Start management studio and the database engine. Start a new query and copy this statement: |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
