Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Predict (MDX)

Updated: 17 July 2006

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.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.

Community Additions

ADD
Show:
© 2014 Microsoft