Export (0) Print
Expand All
Expand Minimize

MiningStructure Element (ASSL)

Defines the structure for a set of mining models.


<MiningStructures>
   <MiningStructure>
      <Name>...</Name>
      <ID>...</ID>
      <Description>...</<Description>
      <Source>...</Source>
      <CreatedTimestamp>...</<CreatedTimestamp>
      <LastSchemaUpdate>...</LastSchemaUpdate>
      <LastProcessed>...</LastProcessed>
      <Translations>...</Translations>
      <Language>...</Language>
            <Collation>...</Collation>
      <ErrorConfiguration>...</ErrorConfiguration>
      <CacheMode>...</CacheMode>
            <Columns>...</Columns>
      <State>...</State>
      <HoldoutActualSize>...</HoldoutActualSize>
      <HoldoutMaxCases>...</HoldoutMaxCases>
      <HoldoutMaxPercent>...</HoldoutMaxPercent>
      <HoldoutSeed>...</HoldoutSeed>      
            <MiningStructurePermissions>...</<MiningStructurePermissions>
            <MiningModels>...</MiningModels>
            <Annotations>...</Annotations>
   </MiningStructure>
</MiningStructures>

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

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.

NoteNote

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 does not support these properties. Therefore, if you try to use these properties on an instance of SQL Server 2005, 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft