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

Content with tag dimension Rss

   Items 1 to 5 of 5   
 

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,820 reads

Insert new values in dimension avoiding deadlock

TSQL code deadlock-safe for inserting new value into dimension  Read more...
By Federico Iori 2012/02/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 1,259 reads

Enforcing surrogate key uniqueness in slowly changing dimension

Enforcing surrogate key uniqueness regards natural key in slowly changing dimension  Read more...
By Federico Iori 2012/01/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 692 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,820 reads

Key column of a dimension in SSAS

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...  Read more...
By Akalya 2009/04/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,244 reads
   Items 1 to 5 of 5   
 
Tags
dwh (2)    
analysis services (ssas) (1)    
blogs (1)    
calculate (1)    
calendar (1)    
complex (1)    
date (1)    
deadlock (1)    
exclusive table lock (1)    
indexed views (1)    
natural key (1)    
normalization (1)    
parameterization (1)    
populate (1)    
reference (1)    
scd (1)    
surrogate key (1)    
tablockx (1)