Database reference - Adventure Works DW

Hierarchy - Fiscal

Hierarchy properties

namevalue
nameFiscal 
parent dimensionDate 
description 
idFiscal Year - Fiscal Quarter 
all memeber nameAll Periods 

Levels

nameidsource attribute idhide member ifperspectives
Fiscal Year  Fiscal Year  Fiscal Year     
Fiscal Semester  Fiscal Semester  Fiscal Semester     
Fiscal Quarter  Fiscal Quarter  Fiscal Quarter     
Month  Month Name  Month Name     
Date  Date  Date     



Documentation generated by SqlSpec