target customer list.dmx

数据仓库开发的很好的一个例子

Select * From
	(SELECT FLATTENED
	  t.[CustomerKey],
	  (SELECT $Probability AS ProdProbability FROM
	   Predict ([DM Demo Cust Purch], Include_Statistics) 
	   WHERE [Model Name] = 'Mountain-200') As ProdList
	From [DM DT 1]
	PREDICTION JOIN
	  SHAPE {
	  OPENQUERY([AdventureWorksDW],
		'SELECT [CustomerKey]
		FROM [dbo].[DMDemoCustTest]
		ORDER BY [CustomerKey]')}
	  APPEND 
	  ({OPENQUERY([AdventureWorksDW],
		'SELECT [ModelName], [CustomerKey]
		FROM [dbo].[DMDemoCustPurch]
		ORDER BY [CustomerKey]')}
		RELATE [CustomerKey] TO [CustomerKey])
		AS [DMDemoCustPurch] AS t
	ON
	  [DM DT 1].[DM Demo Cust Purch].[Model Name] = t.[DMDemoCustPurch].[ModelName] AND
	  [DM DT 1].[Customer Key] = t.[CustomerKey]
) AS ProdQuery
WHERE [ProdList.ProdProbability] >= .8