We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

Syncfusion Feedback

How to read the MDX query at service?

Platform: jQuery |
Control: ejPivotClient

This KB illustrates that how to read MDX query at service.


To read the MDX query at service, refer to the following code example.


public Dictionary<string, object> InitializeClient(string action, string customObject, string clientParams)
            OlapDataManager DataManager = null;
            dynamic customData = serializer.Deserialize<dynamic>(customObject.ToString());
            if (customData.ContainsKey("Language"))
                var cultureIDInfo = new System.Globalization.CultureInfo((customData["Language"])).LCID;
                connectionString = connectionString.Replace("" + cultureIDInfoVal + "", "" + cultureIDInfo + "");
                cultureIDInfoVal = cultureIDInfo;
                DataManager = new OlapDataManager(connectionString);
                DataManager.Culture = new System.Globalization.CultureInfo((customData["Language"]));
                DataManager = new OlapDataManager(connectionString);   
            DataManager.BeforeMdxQueryExecute += DataManager_BeforeMdxQueryExecute;
            return olapClientHelper.GetJsonData(action, DataManager, clientParams);
void DataManager_BeforeMdxQueryExecute(object sender, QueryExecutingEventArgs e)
           //other code



Public Function InitializeClient(ByVal action As String, ByVal customObject As String, ByVal clientParams As String) As Dictionary(Of String, Object)
 Dim DataManager As OlapDataManager = Nothing
 Dim customData As dynamic = serializer.Deserialize(Of dynamic)(customObject.ToString())
 If customData.ContainsKey("Language") Then
 Dim cultureIDInfo = New System.Globalization.CultureInfo((customData("Language"))).LCID
 connectionString = connectionString.Replace("" & cultureIDInfoVal & "", "" & cultureIDInfo & "")
 cultureIDInfoVal = cultureIDInfo
 DataManager = New OlapDataManager(connectionString)
 DataManager.Culture = New System.Globalization.CultureInfo((customData("Language")))
  DataManager = New OlapDataManager(connectionString)
 End If
  AddHandler DataManager.BeforeMdxQueryExecute, AddressOf DataManager_BeforeMdxQueryExecute
  Return olapClientHelper.GetJsonData(action, DataManager, clientParams)
End Function
Private Sub DataManager_BeforeMdxQueryExecute(ByVal sender As Object, ByVal e As QueryExecutingEventArgs)
  'other code
End Sub



You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile