This event is called through the context menu, when MSAS 2005 Drillthrough Action is performed. A result of the Drillthrough query is returned in a DataSet, available in the DrillthroughData property of the e parameter (the DrillthroughActionArgs type). This DataSet contains the only table where the result of the Drillthrough operation is saved to.
The resulting data may be used in any way you like.
For example, the results of the Drillthrough operation in GridView control may be displayed on the same web page with the OLAP Grid.
In this case, in the OnDrillthrough event handler one should write the code like:
protected void TOLAPGrid1_OnDrillthrough(object sender, DrillthroughActionArgs e)
{
GridView1.DataSource = e.DrillthroughData.Tables[0];
GridView1.DataBind();
}
An elaborated example of using this event (when the paging function is enabled in GridView) is given in our demo-application (the TestConnection.aspx page).