回复:使用DMX创建管理挖掘模型
andy 能帮我看看这个DMX查询问题出在哪儿吗?谢谢
报错信息:错误 (数据挖掘): 在第 3 行第 48 列的上下文中找不到指定的 DMX 列。
select
t.RequestsID,
(select $Sequence,PageName,PredictProbability([PageName]) as Histogram
from PredictSequence([ClickPath],2))as Sequences
from Websequence PREDICTION JOIN
SHAPE {
OPENQUERY([EBOOK DW],'select RequestsID from AssocSeqRequest')
}
APPEND (
{OPENQUERY([EBOOK DW],'select RequestsID,LineNumber,PageName from AssocSeqLineURl')}
RELATE RequestsId To RequestsID
)AS ClickPath AS t
ON
WebSequence.RequestsID = t.RequestsID AND
WebSequence.ClickPath.LineNumber = t.ClickPath.LineNumber AND
WebSequence.ClickPath.PageName = t.ClickPath.PageName