SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag date dimension Rss

Search for any content tagged date dimension

   Items 1 to 3 of 3   

Creating a Date Dimension in a Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.  Read more...
By Additional Articles 2016/03/31 | Source: SimpleTalk | Category: tabular model
Rating:  Rate this |   Briefcase | 3,947 reads

Mastering Dimensions of Time

A method to create and populate Date and Time dimension tables for a data warehouse project.  Read more...
By PhyData DBA 2014/01/21 | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 7,326 reads

A Stumbling Count

This article describes how to construct a running count that sometimes stops.  Read more...
By Gijs van Ekert 2011/05/31 | Source: SQLServerCentral.com | Category: running count
Rating: |  Discuss |   Briefcase | 6,044 reads
   Items 1 to 3 of 3