Database reference - Adventure Works DW

Attribute - Postal Code

Attribute properties

namevalue
namePostal Code 
parent dimensionGeography 
description 
default member 
idPostal Code 
typePostalCode 
usage 
estimated count646 
order by 
order by attribute id 
grouping behaviorDiscourageGrouping 
instance selectionFilteredList 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimGeography.PostalCode  WChar  15 

Key columns

namedatatypesize
dbo_DimGeography.PostalCode  WChar   
dbo_DimGeography.City  WChar   

Attribute relationships

nameidcardinality
City  City   

Hierarchy levels referenced

hierarchylevel
Geography  Postal Code

Perspectives where visible

name
Channel Sales 



Documentation generated by SqlSpec