Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Mapping Functions to Query Types (DMX)

You can use functions to control how queries in Data Mining Extensions (DMX) create predictions in Microsoft SQL Server 2005 Analysis Services (SSAS). However, each query type supports specific functions, and some query types do not support certain functions. For general information about functions in DMX, see Data Mining Extensions (DMX) Function Reference.

You can use the SELECT statement in DMX to create different types of queries. Each query type supports different functions. The following table lists the functions that you can use for each type of SELECT statement.

Query type Supported functions

SELECT DISTINCT FROM <model>

RangeMin, RangeMid, RangeMax

for continuous and discretized columns

SELECT FROM <model>.CONTENT

or

SELECT FROM <model>.DIMENSION_CONTENT

IsDescendent

SELECT FROM <model>.CASES

IsInNode, Lag

SELECT FROM <model>.SAMPLE_CASES

IsInNode

SELECT FROM <model>.PMML

Not applicable.

SELECT FROM <model> PREDICTION JOIN

Prediction functions that are specific to the algorithm that you use to build the model.

SELECT FROM <model>

Prediction functions that are specific to the algorithm that you use to build the model.

For a list of the functions that are supported by Microsoft algorithms, see the individual algorithm topics in Data Mining Algorithms.

You can use the following functions for any SELECT statement that returns a table expression:

  • TopCount
  • BottomCount
  • TopPercent
  • BottomPercent
  • TopSum
  • BottomSum
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.