Export (0) Print
Expand All
Expand Minimize

Predict (MDX)

Returns a value of a numeric expression evaluated over a data mining model.


Predict(Mining_Model_Name,Numeric_Expression) 

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft