)
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. (Last updated on: June 24, 2019).
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: ejPivotGrid |
Published Date: June 18, 2019 |
Last Revised Date: June 18, 2019

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

Solution:

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

C#

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"]));
            }
            else
                DataManager = new OlapDataManager(connectionString);   
            DataManager.BeforeMdxQueryExecute += DataManager_BeforeMdxQueryExecute;
            DataManager.SetCurrentReport(CreateOlapReport());
            return olapClientHelper.GetJsonData(action, DataManager, clientParams);
        }
void DataManager_BeforeMdxQueryExecute(object sender, QueryExecutingEventArgs e)
        {
           //other code
        } 

 

 VB

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")))
 Else
  DataManager = New OlapDataManager(connectionString)
 End If
  AddHandler DataManager.BeforeMdxQueryExecute, AddressOf DataManager_BeforeMdxQueryExecute
  DataManager.SetCurrentReport(CreateOlapReport())
  Return olapClientHelper.GetJsonData(action, DataManager, clientParams)
End Function
Private Sub DataManager_BeforeMdxQueryExecute(ByVal sender As Object, ByVal e As QueryExecutingEventArgs)
  'other code
End Sub

 

 

ADD COMMENT
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
Live Chat Icon