Category / Section
How can we modify the MDX query before executing
1 min read
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 }