Database reference - Adventure Works DW

Attribute - Reseller Sales Order

Attribute properties

namevalue
nameReseller Sales Order 
parent dimensionReseller Sales Order Details 
description 
default member 
idFact Reseller Sales 
type 
usageKey 
estimated count60855 
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
dbo_FactResellerSales.SalesOrderDesc  WChar  20 

Key columns

namedatatypesize
dbo_FactResellerSales.SalesOrderNumber  WChar  20 
dbo_FactResellerSales.SalesOrderLineNumber  UnsignedTinyInt   

Attribute relationships

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

Hierarchy levels referenced

hierarchylevel
Reseller Sales Orders  Order Line



Documentation generated by SqlSpec