选择 "从 < 模型" > 。SAMPLE_CASES (DMX) SELECT FROM <model>.SAMPLE_CASES (DMX)

适用于:Applies to: 是 SQL ServerSQL Server Analysis ServicesAnalysis Servicesyes SQL ServerSQL Server Analysis ServicesAnalysis Services适用于:Applies to: 是 SQL ServerSQL Server Analysis ServicesAnalysis Servicesyes SQL ServerSQL Server Analysis ServicesAnalysis Services

返回示例事例,用于代表为数据挖掘模型定型所用的事例。Returns sample cases that are representative of the cases that are used to train the data mining model.

若要使用此语句,必须在创建挖掘模型时启用钻取功能。To use this statement, you must enable drillthrough when you create the mining model. 有关启用钻取的详细信息,请参阅 创建挖掘模型 (dmx)选择 INTO (dmx),并 更改挖掘结构 (dmx)For more information about enabling drillthrough, see CREATE MINING MODEL (DMX), SELECT INTO (DMX), and ALTER MINING STRUCTURE (DMX).

语法Syntax

  
SELECT [FLATTENED] [TOP <n>] <expression list> FROM <model>.SAMPLE_CASES  
[WHERE <condition list>] ORDER BY <expression> [DESC|ASC]]  

参数Arguments

nn
可选。Optional. 一个指定返回行数的整数。An integer that specifies how many rows to return.

表达式列表expression list
相关列标识符的逗号分隔列表。A comma-separated list of related column identifiers.

modelmodel
模型标识符。A model identifier.

条件列表condition list
可选。Optional. 限制条件,用于限制从列列表返回的值。Conditions to restrict the values that are returned from the column list.

expressionexpression
可选。Optional. 一个返回标量值的表达式。An expression that returns a scalar value.

备注Remarks

可能生成样本事例,但其可能并不实际存在于定型数据中。Sample cases may be generated and may not actually exist in the training data. 返回的事例代表指定的内容节点。The returned case is representative of the specified content node.

尽管 MicrosoftMicrosoft 顺序分析和聚类分析算法是唯一 MicrosoftMicrosoft 支持使用 SELECT FROM 的算法 <model> 。SAMPLE_CASES,第三方算法还可以支持该算法。Although the MicrosoftMicrosoft Sequence Clustering algorithm is the only MicrosoftMicrosoft algorithm that supports using SELECT FROM <model>.SAMPLE_CASES, third-party algorithms may also support it.

示例Examples

以下示例可返回为目标邮件挖掘模型定型所用的样本事例。The following example returns sample cases that are used to train the Target Mail mining model. WHERE子句中使用IsInNode (DMX)函数只返回与 "000000003" 节点关联的事例。Using the IsInNode (DMX) function in the WHERE clause returns only cases that are associated with the '000000003' node. 可以在架构行集的 NODE_UNIQUE_NAME 列中找到节点字符串。The node string can be found in the NODE_UNIQUE_NAME column of the schema rowset.

Select * from [Sequence Clustering].SAMPLE_Cases  
WHERE IsInNode('000000003')  

另请参阅See Also

选择 (DMX) SELECT (DMX)
数据挖掘扩展插件 (DMX) 数据定义语句 Data Mining Extensions (DMX) Data Definition Statements
数据挖掘扩展插件 (DMX) 数据操作语句 Data Mining Extensions (DMX) Data Manipulation Statements
数据挖掘扩展插件 (DMX) 语句引用Data Mining Extensions (DMX) Statement Reference