OLAP Cube with DrillThrough Example

[Simone]

Hi, I try to use  drillThrough with OLAP Cube. I use this connection string but this cube return me an error with relation engine. Can you send me example with drill through and OLAP Cube that working? Thank you.

[Scintilla Arul Jothi Raj]

  

Hi Simone,   

  

Thanks for contacting Syncfusion Support,  

  

We have prepared sample based on your requirement.  To work with drill-through, the option needs to be enabled at cube level and kindly ensure that at your end. Also “layout” needs to be passed in drillthroughHierarchies function. Please refer the below code snippet in controller file.   

 

Code Snippet:[C#] 

[System.Web.Http.ActionName("DrillThroughHierarchies")] 

[System.Web.Http.HttpPost] 

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

{ 

   var layout = "normal"; 

OlapDataManager DataManager = new OlapDataManager(connectionString); 

DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(jsonResult["currentReport"].ToString())); 

return olapClientHelper.DrillthroughHierarchies(DataManager, layout, jsonResult["cellPos"].ToString()); 

} 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/136609/ze/DrillThrough1091130544 

 

And we are facing issue with hierarchy selector option in drill-through dialog (“Exception occurs while using hierarchy option in drillThrough feature”)  and logged a defect report. The fix for this issue will be available in the upcoming Essential Studio 2018 Volume 1 Service Pack Release 2 which is estimated to be roll out by end of April 2018.  

 

Please let us know, if you have any concern. 

 

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 using heirarchy option in drillthrough feature” 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