Creating Time Dimension in Microsoft Analysis Services

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.