Database reference - Adventure Works DW

Attribute - Fiscal Year

Attribute properties

namevalue
nameFiscal Year 
parent dimensionDate 
description 
default member 
idFiscal Year 
typeFiscalYears 
usage 
estimated count
order byKey 
order by attribute id 
grouping behavior 
instance selectionDropDown 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folderFiscal 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimTime.FiscalYearDesc  WChar   

Key columns

namedatatypesize
dbo_DimTime.FiscalYear  WChar 

Hierarchy levels referenced

hierarchylevel
Fiscal  Fiscal Year

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