IMiningModelDrillThroughHandler.ShowDrillThrough Method
Displays the results of the specified drillthrough operation.
Namespace: Microsoft.DataWarehouse.Interfaces
Assembly: Microsoft.DataWarehouse.Interfaces (in Microsoft.DataWarehouse.Interfaces.dll)
Syntax
'Declaration
Sub ShowDrillThrough
'Usage
Dim instance As IMiningModelDrillThroughHandler
instance.ShowDrillThrough()
void ShowDrillThrough()
void ShowDrillThrough()
abstract ShowDrillThrough : unit -> unit
function ShowDrillThrough()
Remarks
The ShowDrillThrough method is called when drill-through results need to be displayed.
For more information about drillthrough, see Using Drillthrough on Mining Models and Mining Structures (Analysis Services - Data Mining). For information about setting drillthrough permissions, see AllowDrillThrough and AllowDrillThrough.
For example, if a user in SQL Server Management Studio opens a mining model in the viewer and selects one of the drillthrough options from the shortcut menu, the ShowDrillThrough method is called to display drillthrough results for the selected node.
Hosting applications can use the Connection and QueryString properties to construct and execute the command used in the ShowDrillThrough method. Other properties, such as MiningModelName and NodeText) can be used with the ShowDrillThrough method to indicate the model and node that the drillthrough results apply to.
The following example illustrates the use of this method:
Examples
public void ShowDrillThrough()
{
IDbCommand command = Connection.CreateCommand();
command.CommandText = QueryString;
IDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess);
while (reader.Read())
{
// Render this row.
}
}