Database reference - Adventure Works DW

Attribute - Calendar Quarter

Attribute properties

namevalue
nameCalendar Quarter 
parent dimensionDate 
description 
default member 
idCalendarQuarterDesc 
typeQuarters 
usage 
estimated count13 
order byKey 
order by attribute id 
grouping behavior 
instance selectionDropDown 
attribute hierarchy visiblefalse 
attribute hierarchy enabled 
attribute hierarchy display folderCalendar 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimTime.CalendarQuarterDesc  WChar   

Key columns

namedatatypesize
dbo_DimTime.CalendarYear  WChar   
dbo_DimTime.CalendarQuarter  WChar   

Attribute relationships

nameidcardinality
Fiscal Quarter  FiscalQuarterDesc   
Calendar Semester  CalendarSemesterDesc   
Calendar Semester of Year  CalendarSemesterOfYearDesc   
Calendar Quarter of Year  CalendarQuarterOfYear   

Hierarchy levels referenced

hierarchylevel
Calendar  Calendar Quarter

Perspectives where visible

name
Direct Sales 
Direct Sales 
Direct Sales 
Channel Sales 
Channel Sales 
Channel Sales 
Sales Summary 
Sales Summary 
Sales Summary 
Finance 
Sales Targets 



Documentation generated by SqlSpec