Category / Section
How to edit the MDX queries before loading data in OlapClient
1 min read
The MDX queries can be edited before loading the data in the OlapClient. This can be achieved using the “BeforeMdxQueryExecute” event. Please refer the following code snippet.
C#
public MainWindow() { ViewModel.ViewModel.ConnectionString = this.GetConnectionString(); InitializeComponent(); this.olapClient1.OlapDataManager.BeforeMdxQueryExecute += OlapDataManager_BeforeMdxQueryExecute; } void OlapDataManager_BeforeMdxQueryExecute(object sender, Syncfusion.Olap.Manager.QueryExecutingEventArgs e) { e.MdxQuery = ""; // Assign your MDX query here. }
VB
Public Sub New() ViewModel.ViewModel.ConnectionString = Me.GetConnectionString() InitializeComponent() AddHandler Me.olapClient1.OlapDataManager.BeforeMdxQueryExecute, AddressOf OlapDataManager_BeforeMdxQueryExecute End Sub Private Sub OlapDataManager_BeforeMdxQueryExecute(ByVal sender As Object, ByVal e As Syncfusion.Olap.Manager.QueryExecutingEventArgs) e.MdxQuery = "" ' Assign your MDX query here. End Sub