Database reference - Adventure Works DW

Hierarchy - Product Model Lines

Hierarchy properties

namevalue
nameProduct Model Lines 
parent dimensionProduct 
description 
idHierarchy 1 
all memeber nameAll Products 

Levels

nameidsource attribute idhide member ifperspectives
Product Line  Product Line  Product Line     
Model  Model Name  Model Name     

Perspectives where visible

name
Direct Sales 
Channel Sales 
Sales Summary 



Documentation generated by SqlSpec