Predict (MDX)
Returns a value of a numeric expression evaluated over a data mining model.
Syntax
Predict(Mining_Model_Name,Numeric_Expression)
Arguments
Mining_Model_Name
A valid string expression that represents the name of a mining model.Numeric_Expression
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.
Remarks
The Predict function evaluates the specified numeric expression within the context of the specified mining model.
Data mining syntax and functions are documented in the OLE DB for Data Mining specification. For more information about the OLE DB for Data Mining specification, see Microsoft OLE DB on MSDN.
Example
The following example predicts the top five most likely UrlCategory items, based on the history in the mining model.
SELECT FLATTENED TopCount
(Predict
(SiteAffiliation.WebClick, INCLUDE_STATISTICS)
, $Probability, 5)
FROM SiteAffiliation PREDICTION JOIN
(SELECT (SELECT 'url-1' AS UrlCategory UNION
(SELECT 'url-2' AS UrlCategory) AS WebClick) AS input
ON SiteAffiliation.WebClick.UrlCategory = input.WebClick.UrlCategory
For more information about this example, see "Algorithm Details" in Frequently Asked Questions: Data Mining on MSDN.