Database reference - Adventure Works DW

Attribute - Postal Code

Attribute properties

namevalue
namePostal Code 
parent dimensionCustomer 
description 
default member 
idDbo Dim Geography - Postal Code 
typePostalCode 
usage 
estimated count646 
order by 
order by attribute id 
grouping behavior 
instance selectionFilteredList 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folderLocation 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimGeography.PostalCode  WChar  15 

Key columns

namedatatypesize
dbo_DimGeography.PostalCode  WChar  15 
dbo_DimGeography.City  WChar   

Attribute relationships

nameidcardinality
City  Dbo Dim Geography - City   

Hierarchy levels referenced

hierarchylevel
Customer Geography  Postal Code

Perspectives where visible

name
Direct Sales 



Documentation generated by SqlSpec