Database reference - AmoAdventureWorks

Dimension - Date

Dimension properties

namevalue
nameDate 
idDate 
description 
created8/26/2006 10:06:08 PM 
last schema update8/26/2006 10:06:08 PM 
loadedTrue 
last processed8/26/2006 10:06:23 PM  
stateProcessed  
typeTime  
language1033  
collationLatin1_General_CI_AS  
unknown member nameUnknown 
attribute all member nameAll Periods 
data source viewAdventureWorksDW 

Attributes

namedescriptionidtypeusageestimated count
Date.Calendar Month Name    Calendar Month Name  Months     
Date.Calendar Month Number    Calendar Month Number  MonthOfYear     
Date.Calendar Quarter    Calendar Quarter  Quarters     
Date.Calendar Semester    Calendar Semester  HalfYears     
Date.Calendar Year    Calendar Year  Years     
Date.Date    Date  Date  Key   
Date.Fiscal Month Name    Fiscal Month Name  FiscalMonths     
Date.Fiscal Month Number    Fiscal Month Number  FiscalMonthOfYear     
Date.Fiscal Quarter    Fiscal Quarter  FiscalQuarters     
Date.Fiscal Semester    Fiscal Semester  FiscalHalfYears     
Date.Fiscal Year    Fiscal Year  FiscalYears     

Hierarchies

namedescriptionidall member name
Calendar Time    Calendar Time  All Periods 
Fiscal Time    Fiscal Time  All Periods 

Proactive caching properties

namevalue
silence interval-PT1S 
latency-PT1S 
silence override interval-PT1S 
force rebuild interval-PT1S 
aggregation storage 
online mode 
source typeProactiveCachingInheritedBinding 
source notification technique 

Dependency graph

AmoAdventureWorksAdventureWorksDWAdventureWorksDWDateAdventure WorksAdventure Works DateAdventure Works Delivery DateAdventure Works Ship Date
Legend
tabledatabase
cubemeasure group
data sourcedimension
role
mining structuremining model
data source viewdatabase permission

Code

Dimension.Date.xmla



Documentation generated by SqlSpec