Working Example Olap mode Server-Side

[Simone]

Hi, I'm trying to do an example with Olap but I can't find one. Can you send me a sample project with Olap, your example service, web api controller and server mode?thank you

[Simone]

Hi, I'm trying to do an example with Olap but I can't find one. Can you send me a sample project with Olap, your example service, web api controller and server mode?thank you

And I want to add Drill Through to grid into PivotClient. When I use

 .EnableDrillThrough(true) 

say to me -> "reference not set to an object instance"

[Scintilla Arul Jothi Raj]

Hi Simone, 

Thanks for contacting Syncfusion Support.  

We have prepared a PivotClient server-side sample as per your requirement. Please find the sample and document in the below link. 

Sample Link: http://www.syncfusion.com/downloads/support/forum/136452/ze/PivotClientDemo350711189 

 

Kindly refer the “Getting Started” documentation link below for more details. 

Documentation Link: https://help.syncfusion.com/aspnetmvc/pivotclient/olap-getting-started#creating-a-simple-application-with-pivotclient-and-olap-datasource-server-mode 

Regards, 

Scintilla A.

[Simone]

I want to add Drill Through to grid into PivotClient. When I use

 .EnableDrillThrough(true) 

say to me -> "reference not set to an object instance" into method    [System.Web.Http.ActionName("InitializeGrid")]
[System.Web.Http.HttpPost]
public Dictionary<string, object> InitializeGrid(Dictionary<string, object> jsonResult)
{
      OlapDataManager DataManager = new OlapDataManager(connectionString);
      DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(jsonResult["currentReport"].ToString()));
      ---->>>>>> return jsonResult.ContainsKey("gridLayout") ? pivotClientHelper.GetJsonData(jsonResult["action"].ToString(), DataManager,  jsonResult["gridLayout"].ToString()) : pivotClientHelper.GetJsonData(jsonResult["action"].ToString(), DataManager);
}

This is method that broke into webapi controller.

[Scintilla Arul Jothi Raj]

Hi Simone,   

Sorry for the inconvenience caused.   

We confirmed that “Exception occurs while clicking drillthrough enabled cell” is an issue and logged a defect report. The fix for the issue is available in our upcoming Essential Studio 2018 Volume 1 Service Pack 2 release which is estimated to be rolled out on end of April 2018. Currently, we have provided work around solution in the controller file. Please refer the code snippet below.  

 

Code Snippet: [C#] 

public Dictionary<string, object> InitializeGrid(Dictionary<string, object> jsonResult) 

{ 

    jsonResult["action"] = "initializeGrid"; 

    OlapDataManager DataManager = new OlapDataManager(connectionString); 

    //…             

} 

 

Meanwhile, we have included the changes in controller file. Please find the file in the below link. 

http://www.syncfusion.com/downloads/support/forum/136452/ze/OlapClientController-1079891695 

 

Regards, 

Scintilla A 

[Scintilla Arul Jothi Raj]

 Hi Simone, 

We are glad to announce that our Essential Studio Volume 1, SP 2 2018 (v16.1.0.37) is rolled out and is available for download under the following link. 

https://www.syncfusion.com/forums/137209/essential-studio-2018-volume-1-service-pack-release-v16-1-0-37-available-for-download             

The fix for the issue “Exception occurs while clicking drillthrough enabled cell” is included in this version. We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 

Scintilla A