Database reference - Adventure Works DW

Attribute - Sales Order Number

Attribute properties

namevalue
nameSales Order Number 
parent dimensionSales Summary Order Details 
description 
default member 
idSales Order Number 
type 
usage 
estimated count31455 
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
FactSalesSummary.SalesOrderNumber  WChar  20 

Key columns

namedatatypesize
FactSalesSummary.SalesOrderNumber  WChar  20 

Hierarchy levels referenced

hierarchylevel
Sales Orders  Order Number

Perspectives where visible

name
Sales Summary 



Documentation generated by SqlSpec