Skip to content

Latest commit

 

History

History
62 lines (44 loc) · 2.83 KB

holdoutmaxpercent-element.md

File metadata and controls

62 lines (44 loc) · 2.83 KB
Raw
title description ms.date ms.service ms.custom ms.reviewer ms.topic author ms.author
HoldoutMaxPercent Element | Microsoft Docs
Learn about the HoldoutMaxPercent property element in the Analysis Services Scripting Language (ASSL) schema.
7/25/2018
analysis-services
assl
kfollis
reference
kfollis
kfollis

HoldoutMaxPercent Element

Specifies the maximum percentage of cases in the data source that will be used for the holdout partition that contains the test set of a MiningStructure element. The remaining cases are used for training. A value of 0 indicates that there is no limit to the number of cases that can be held out as the test set.

Syntax

  
<MiningStructure>  
   ...  
   <ddl100_100:HoldoutMaxPercent>...</ddl100_100:HoldoutMaxPercent>  
   ...  
</MiningStructure>

Element Characteristics

Characteristic Description
Data type and length Integer between 0 and 99.
Default value 30
Cardinality 0-1: Optional element that can occur one time and one time only.

Element Relationships

Relationship Element
Parent element MiningStructure
Child elements None

Remarks

If you specify values for both HoldoutMaxPercent and HoldoutMaxCases, the algorithm limits the test set to the smaller of the two values.

If HoldoutMaxCases is set to the default of 0, and a value has not been set for HoldoutMaxPercent, the algorithm uses the complete data set for training.

The new properties HoldoutMaxCases, HoldoutMaxPercent, HoldoutSeed, or HoldoutActualSize are available only in SQL Server 2008 and later versions. Therefore, you must prefix these properties by using the new namespace as shown in the syntax description, orAnalysis Services will return an error.

Note

In SQL Server 2005,Analysis Services did not support the use of holdout partitions on a mining structure. Therefore,Analysis Services Scripting Language (ASSL) statements that contain one of the holdout parameters, HoldoutMaxCases, HoldoutMaxPercent, HoldoutSeed, or HoldoutActualSize, cannot be used in SQL Server 2005. If you use one of these holdout parameters in an ASSL statement in SQL Server 2005,Analysis Services will return an error.

The element that corresponds to the parent of HoldoutMaxPercent in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.MiningStructure.

See Also

Properties (ASSL)
HoldoutMaxCases Element
HoldoutSeed Element
HoldoutActualSize Element