Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Determines whether drillthrough is permitted on the parent element.
Syntax
<MiningModel> <!-- or MiningModelPermission -->
<!-- or MiningStructurePermission --> ...
<AllowDrillThrough>...</AllowDrillThrough>
...
</MiningModel>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | Boolean |
| Default value | False |
| Cardinality | 0-1: Optional element that can occur one time and only one time. |
Element Relationships
| Relationship | Element |
|---|---|
| Parent elements | MiningModel Element, MiningModelPermission, MiningStructurePermission |
| Child elements | None |
Remarks
In the Analysis Management Objects (AMO) object model, the parents of AllowDrillThrough are MiningModel, MiningModelPermission, and MiningStructurePermission.
Drillthrough on mining structures
SQL Server lets you define AllowDrillthrough permissions for mining structures and 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 weren't 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.
To protect sensitive data, carefully choose which columns you add to the mining structure. Also, grant AllowDrillthrough permission on a structure only when it's required.
To drill through to structure columns, use a query with one of the following forms:
SELECT * FROM <structure>.CASES
or
SELECT StructureColumn('<structure-column-name>') FROM <model>.CASES