Delen via

Predict (MDX)

  • Artikel

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.

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

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