Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag time dimension Rss

   Items 1 to 5 of 5   
 

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,223 reads

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis

Getting the time dimension configured correctly is a necessary first step in order to take advantage of the Time Intelligence features in SSAS.  Read more...
By 2011/08/04 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,777 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,535 reads

Creating Custom Calendars in SQL Server Analysis Services

Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.  Read more...
By Andrew Muyobo 2010/09/28 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 4,978 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,535 reads
   Items 1 to 5 of 5   
 
Tags
analysis services (ssas) (2)    
date dimension (2)    
custom calendars (1)    
data warehouse (1)    
dimension tables (1)