Category / Section
How to edit the MDX queries before loading data in OlapClient
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