How can we modify the MDX query before executing
We can able to modify the MDX query before loading data in OlapClient. This can be achieved using “BeforeMdxQueryExecute” event.
Please refer the below code snippet.
C#
public OlapManager()
{
string connectionString = this.GetConnectionString();
_dataManager = new OlapDataProvider(connectionString);
_dataManager.BeforeMdxQueryExecute += _dataManager_BeforeMdxQueryExecute;
}
void _dataManager_BeforeMdxQueryExecute(object sender, Syncfusion.Olap.Manager.QueryExecutingEventArgs e)
{
e.MdxQuery = ""; // Assign your MDX query here
}
