Database reference - Adventure Works DW

Attribute - Sales Order Line

Attribute properties

namevalue
nameSales Order Line 
parent dimensionSales Summary Order Details 
description 
default member 
idSales Order Line Number 
type 
usage 
estimated count 
order byKey 
order by attribute id 
grouping behaviorDiscourageGrouping 
instance selectionDropDown 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
FactSalesSummary.SalesOrderLineNumber  WChar  -1 

Key columns

namedatatypesize
FactSalesSummary.SalesOrderLineNumber  UnsignedTinyInt  -1 

Hierarchy levels referenced

hierarchylevel
Sales Orders  Order Line

Perspectives where visible

name
Sales Summary 



Documentation generated by SqlSpec