MiningStructurePermission.AllowDrillThrough Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets or sets a value that indicates whether drillthrough is enabled on the mining structure.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

Syntax

[DefaultValueAttribute(false)]
public bool AllowDrillThrough { get; set; }

public:
[DefaultValueAttribute(false)]
property bool AllowDrillThrough {
    bool get();
    void set(bool value);
}

[<DefaultValueAttribute(false)>]
member AllowDrillThrough : bool with get, set

<DefaultValueAttribute(False)>
Public Property AllowDrillThrough As Boolean

Property Value

Type: System.Boolean

true if drillthrough is enabled; otherwise false. The default is false.

Remarks

When drillthrough is enabled on a mining structure, users who are members of a role that has drillthrough permission can view all the columns in the mining structure, by using the following syntax:

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

Moreover, a user who also has drillthrough access to the mining model and the mining structure can retrieve information from columns that are not used in the mining model, by using the following syntax:

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

Therefore, to protect personal information, you should set up the underlying data source view to mask confidential information, and enable drillthrough permissions on a mining structure only when necessary.

See Also

MiningStructurePermission Class
Microsoft.AnalysisServices Namespace

Return to top