Database reference - Adventure Works DW

Attribute - Sales Order Number

Attribute properties

namevalue
nameSales Order Number 
parent dimensionReseller Sales Order Details 
description 
default member 
idSalesOrderNumber 
type 
usage 
estimated count3796 
order byKey 
order by attribute id 
grouping behavior 
instance selectionMandatoryFilter 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_FactResellerSales.SalesOrderNumber  WChar  20 

Key columns

namedatatypesize
dbo_FactResellerSales.SalesOrderNumber  WChar  20 

Hierarchy levels referenced

hierarchylevel
Reseller Sales Orders  Order Number
Internet Sales Orders  Order Number

Perspectives where visible

name
Direct Sales 
Channel Sales 



Documentation generated by SqlSpec