SSAS Articles 
Time Dimension Creating Time Dimension in Microsoft Analysis Services
Time Dimension Creating Time Dimension in Microsoft Analysis Services
| Creating Time Dimension in Microsoft Analysis Services |
| Written by Igor Krupitsky |
| Saturday, 28 June 2008 02:17 |
|
Sometime you need to create a report on the time level (Hour, Minutes and Seconds). For a relational report you can use DATEPART() function to extract the time information out of a DateTime column. However, doing this is difficult for an OLAP report. This article explains how to create a Time Dimension table and use it inside SSAS. To understand this article you need to understand the basics of dimensional modeling and Microsoft SQL Server Analysis Services. Read more... |
Tags: 2005, article, introduction, time dimension
Latest Author Articles
All articles by Igor KrupitskyTop Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- 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)
