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
