AllowDrillThrough Element (ASSL)
Applies To: SQL Server 2016 Preview
Determines whether drillthrough is permitted on the parent element.
<MiningModel> <!-- or MiningModelPermission --> <!-- or MiningStructurePermission --> ... <AllowDrillThrough>...</AllowDrillThrough> ... </MiningModel>
|Data type and length||Boolean|
|Cardinality||0-1: Optional element that can occur one time and only one time.|
|Parent elements||MiningModel Element, MiningModelPermission, MiningStructurePermission|
In SQL Server 2016, you can define AllowDrillthrough permissions for mining structures as well as mining models. When you assign this permission to a role, any member of that role can query the data mining model, and return structure columns that were not included in the model. For example, you create a model that uses only these columns: customer key, customer income, and customer purchases. If you enable drillthrough on the model, users can return information in other columns of the mining structure, such as customer e-mails or names.
Therefore, to protect sensitive data, use caution when you add columns to the mining structure. Also, grant AllowDrillthrough permission on a structure only when it is required.
To drill through to structure columns, use a query with one of the following forms:
SELECT * FROM <structure>.CASES
SELECT StructureColumn('<structure-column-name>') FROM <model>.CASES