Database reference - Adventure Works DW

Attribute - Fiscal Semester

Attribute properties

namevalue
nameFiscal Semester 
parent dimensionDate 
description 
default member 
idFiscalSemesterDesc 
typeFiscalHalfYears 
usage 
estimated count
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.FiscalSemesterDesc  WChar   

Key columns

namedatatypesize
dbo_DimTime.FiscalYear  WChar   
dbo_DimTime.FiscalSemester  WChar   

Attribute relationships

nameidcardinality
Fiscal Year  Fiscal Year   

Hierarchy levels referenced

hierarchylevel
Fiscal  Fiscal Semester

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