Database reference - Adventure Works DW

MiningModel - Subcategory Associations

Mining model properties

name	value
name	Subcategory Associations
description
id	Subcategory Associations
algorithm	Microsoft_Association_Rules
allow drill through	true
language	1033
collation	Latin1_General_CI_AS

Columns

name	id	source column id	usage
Customer Counts 1	Customer	Customer	Key
Subcategories	Subcategories	Internet Sales	Predict

Dependency graph

Customer MiningSubcategory Associations Subcategory Basket Analysis

Objects that Subcategory Associations depends on

name	object type	level
Customer Mining	MiningStructure	1
Adventure Works DW	DataSourceView	2
Sales Summary Order Details	Dimension	2
Destination Currency	Dimension	2
Sales Channel	Dimension	2
Internet Sales Order Details	Dimension	2
Reseller Sales Order Details	Dimension	2
Sales Reason	Dimension	2
Source Currency	Dimension	2
Date	Dimension	2
Account	Dimension	2
Organization	Dimension	2
Department	Dimension	2
Scenario	Dimension	2
Employee	Dimension	2
Sales Territory	Dimension	2
Geography	Dimension	2
Product	Dimension	2
Promotion	Dimension	2

Objects that depend on Subcategory Associations

name	object type	level
Subcategory Basket Analysis	Dimension	1
Mined Customers Subcategory Basket Analysis	CubeDimension	2
Mined Customers Internet Customers	MeasureGroup	3
Mined Customers Internet Orders	MeasureGroup	3
Mined Customers Internet Sales	MeasureGroup	3

Code

MiningModel.SubcategoryAssociations.xmla

Documentation generated by SqlSpec