Database reference - Adventure Works DW

Attribute - Sales Territory Region

Attribute properties

namevalue
nameSales Territory Region 
parent dimensionSales Territory 
description 
default member 
idSales Territory Region 
type 
usageKey 
estimated count11 
order by 
order by attribute id 
grouping behaviorDiscourageGrouping 
instance selectionDropDown 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimSalesTerritory.SalesTerritoryRegion  WChar  50 

Key columns

namedatatypesize
dbo_DimSalesTerritory.SalesTerritoryKey  Integer  -1 

Attribute relationships

nameidcardinality
Sales Territory Country  Sales Territory Country   

Hierarchy levels referenced

hierarchylevel
Sales Territory  Region

Perspectives where visible

name
Direct Sales 
Channel Sales 
Sales Summary 
Sales Targets 



Documentation generated by SqlSpec