Edit MDX Query before Its Execution

1 Nov 2019 / 1 minute to read

MDX Query can be edited before its execution to retrieve the CellSet through handling the BeforeMdxQueryExecute event of OlapDataManager. The following code example illustrates this.

olapDataManager.BeforeMdxQueryExecute += new QueryExecuteEventHandler(olapDataManager_BeforeMdxQueryExecute);



void olapDataManager_BeforeMdxQueryExecute(object sender, QueryExecutingEventArgs e)

{

     e.MdxQuery = "Edit MDX query here";

}
Private olapDataManager.BeforeMdxQueryExecute += New QueryExecuteEventHandler(AddressOf olapDataManager_BeforeMdxQueryExecute)



Private Sub olapDataManager_BeforeMdxQueryExecute(ByVal sender As Object, ByVal e As QueryExecutingEventArgs)

        e.MdxQuery = "Edit MDX query here"

End Sub