Creating the date and time dimensions

The date and time dimensions (sometimes also referred to as periodicity dimensions) are essential for the majority of data warehousing and business intelligence solutions. Analysis Services offers a couple of different options for creating time dimensions; you can create a corresponding table that contains the necessary columns in the relational database, or use a time dimension defined on the Analysis Services server. Creating the time dimension using a table in the underlying data source isn't very different from creating other dimensions; the primary difference is that you advise Analysis Services that the dimension you're creating should be of the time dimension type. This enables you to use certain MDX ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.