MiningStructure Element (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Defines the structure for a set of mining models.



Element Characteristics

Characteristic Description
Data type and length None
Default value None
Cardinality 0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element
Parent elements MiningStructures
Child elements Annotations, CacheMode, Collation, Columns, CreatedTimestamp, Description, ErrorConfiguration,





ID, Language, LastProcessed, LastSchemaUpdate, MiningModels, MiningStructurePermissions, Name, Source, State, Translations


The mining structure defines the columns and the bindings. After defining a mining structure, you can use that structure to define many mining models. The mining structure, and each mining model it contains, can be processed independently.


The holdout properties, HoldoutMaxCases, HoldoutMaxPercent, HoldoutSeed, and HoldoutActualSize, were introduced in SQL Server 2008. They enable you to define a partition on a mining structure that acts as the test set for all the mining models that are associated with the structure. SQL Server 2005 (9.x) does not support these properties. Therefore, if you try to use these properties on an instance of SQL Server 2005 (9.x), Analysis Services will return an error.

Drillthrough to Structure Columns

In SQL Server 2008, a new permission element has been added to the MiningStructurePermissions Element (ASSL) collection. If you add AllowDrillthrough permission to both the MiningStructurePermissions and MiningModelPermission collections, drillthrough is enabled from the mining model to the structure, in such a way that members of a role that has AllowDrillthrough permissions on the model can query the data mining model, and return structure columns that were not included in the model.

Therefore, to protect sensitive data or personal information, you should construct your data source view to mask sensitive information, and grant AllowDrillthrough permission on a mining structure only when necessary. For more information, see AllowDrillThrough Element (ASSL).

The corresponding element in the Analysis Management Objects (AMO) object model is MiningStructure.

See Also

MiningModel Element (ASSL)
Objects (ASSL)