MiningStructurePermission Element (ASSL)

Defines the permissions that members of a Role element have on an individual MiningStructure element.

Syntax

  
<MiningStructurePermissions>  
   <MiningStructurePermission xsi:type="Permission">  
      <AllowDrillthrough>...</AllowDrillthrough>  
  
      <!-- This element also inherits all the child elements listed in Permission -->  
   </MiningStructurePermission>  
</MiningStructurePermissions>  

Element Characteristics

Element Relationships

Remarks

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

In SQL Server, the AllowDrillthrough permission applies to mining structures. When you assign this permission to a role, any user who is a member of that role can directly query the mining structure by using the following syntax:

SELECT <structure column list> FROM <structure>.CASES  

Moreover, if AllowDrillthrough is enabled on both the mining structure and the mining model, users can query structure columns that weren't included in the mining model by using the following syntax:

SELECT StructureColumn('<structure column name>' FROM <model>.CASES  

For example, suppose a model includes only columns for customer key, customer income, and customer purchases. Drillthrough lets users return other structure columns that the model doesn't include, like customer contact information.

To protect sensitive or personal data, mask it in the data source view and grant the AllowDrillthrough permission on a structure only when necessary.