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