Click here to monitor SSC
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,507 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,306 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 | 5,995 reads
   Items 1 to 3 of 3