Database reference - Adventure Works DW

Attribute - Sales Order

Attribute properties

namevalue
nameSales Order 
parent dimensionSales Summary Order Details 
description 
default member 
idFact Sales Summary 
type 
usageKey 
estimated count121253 
order byKey 
order by attribute id 
grouping behaviorDiscourageGrouping 
instance selectionMandatoryFilter 
attribute hierarchy visiblefalse 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
FactSalesSummary.SalesOrderDesc  WChar  19 

Key columns

namedatatypesize
FactSalesSummary.SalesOrderNumber  WChar  20 
FactSalesSummary.SalesOrderLineNumber  UnsignedTinyInt   

Attribute relationships

nameidcardinality
Carrier Tracking Number  Carrier Tracking Number   
Customer PO Number  Customer PO Number   
Sales Order Number  Sales Order Number   
Sales Order Line  Sales Order Line Number   

Perspectives where visible

name
Sales Summary 
Sales Summary 



Documentation generated by SqlSpec