Skip to content

predictsequence-dmx.md

Latest commit

 

History

History
51 lines (38 loc) · 1.57 KB

predictsequence-dmx.md

File metadata and controls

51 lines (38 loc) · 1.57 KB
title PredictSequence (DMX) | Microsoft Docs
ms.date 06/07/2018
ms.prod sql
ms.technology analysis-services
ms.custom dmx
ms.topic conceptual
ms.author owend
ms.reviewer owend
author minewiskan

PredictSequence (DMX)

[!INCLUDEssas-appliesto-sqlas]

Predicts future sequence values for a specified set of sequence data.

Syntax

  
PredictSequence(<table column reference>)  
PredictSequence(\<table column reference, n>)  
PredictSequence(\<table column reference, n-start, n-end>)

Return Type

A <table expression>.

Remarks

If the n parameter is specified, it returns the following values:

  • If n is greater than zero, the most likely sequence values in the next n steps.

  • If both n-start and n-end are specified, the sequence values from n-start to n-end.

Examples

The following example returns a sequence of the five products that are most likely to be purchased by a customer in the [!INCLUDEssAWDWsp] database based on the Sequence Clustering mining model.

SELECT  
  PredictSequence([Sequence Clustering].[v Assoc Seq Line Items],5)  
From  
  [Sequence Clustering]

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)