1. Home
  2. Forum
  3. ASP.NET MVC
  4. Working Example Olap mode Server-Side

Working Example Olap mode Server-Side

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

5 Replies
SI Simone replied to Simone March 15, 2018 01:41 PM UTC

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"

SA Scintilla Arul Jothi Raj Syncfusion Team March 15, 2018 01:59 PM UTC

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. 

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

Regards, 
Scintilla A.

SI Simone March 16, 2018 08:48 AM UTC

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.

SA Scintilla Arul Jothi Raj Syncfusion Team March 19, 2018 12:54 PM UTC

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. 
 
Regards, 
Scintilla A 


SA Scintilla Arul Jothi Raj Syncfusion Team April 25, 2018 04:47 PM UTC

 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. 
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 


Loader.
Up arrow icon