Database reference - Adventure Works DW

Attribute - Sales Territory Country

Attribute properties

namevalue
nameSales Territory Country 
parent dimensionSales Territory 
description 
default member 
idSales Territory Country 
typeCountry 
usage 
estimated count7 
order by 
order by attribute id 
grouping behavior 
instance selectionDropDown 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimSalesTerritory.SalesTerritoryCountry  WChar  50 

Key columns

namedatatypesize
dbo_DimSalesTerritory.SalesTerritoryCountry  WChar  50 

Attribute relationships

nameidcardinality
Sales Territory Group  Sales Territory Group   

Hierarchy levels referenced

hierarchylevel
Sales Territory  Country

Perspectives where visible

name
Direct Sales 
Channel Sales 
Sales Summary 
Sales Targets 



Documentation generated by SqlSpec