Database reference - Adventure Works DW

Attribute - Fiscal Quarter

Attribute properties

namevalue
nameFiscal Quarter 
parent dimensionDate 
description 
default member 
idFiscalQuarterDesc 
typeFiscalQuarters 
usage 
estimated count13 
order byKey 
order by attribute id 
grouping behavior 
instance selectionDropDown 
attribute hierarchy visiblefalse 
attribute hierarchy enabled 
attribute hierarchy display folderFiscal 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimTime.FiscalQuarterDesc  WChar   

Key columns

namedatatypesize
dbo_DimTime.FiscalYear  WChar   
dbo_DimTime.FiscalQuarter  WChar   

Attribute relationships

nameidcardinality
Fiscal Semester  FiscalSemesterDesc   
Fiscal Semester of Year  FiscalSemesterOfYearDesc   
Fiscal Quarter of Year  FiscalQuarterOfYearDesc   

Hierarchy levels referenced

hierarchylevel
Fiscal  Fiscal 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