Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag date dimension Rss

   Items 1 to 6 of 6   
 

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,435 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,305 reads

Create and Populate a Date Dimension Table

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes  Read more...
By Joseph Morgan 2013/02/04 | Source: SQLServerCentral.com | Category: date dimension
Rating: |  Discuss |   Briefcase | 1,385 reads

Date Dimensions in T-SQL using CTE

T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.  Read more...
By Bhudev Prakash 2011/07/04 | Source: SQLServerCentral.com | Category: time dimension
Rating: |  Discuss |   Briefcase | 3,649 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,993 reads

Date Dimensions in T-SQL using CTE

T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.  Read more...
By Bhudev Prakash 2011/07/04 | Source: SQLServerCentral.com | Category: time dimension
Rating: |  Discuss |   Briefcase | 3,649 reads
   Items 1 to 6 of 6   
 
Tags
data warehouse (2)    
time dimension (2)    
data mart (1)    
dimension tables (1)    
running count (1)    
tabular model (1)    
t-sql (1)