Write Back in EJ 1 ASP.NET MVC PivotGrid
11 Feb 2019 / 1 minute to read
IMPORTANT
This feature is applicable only for OLAP datasource only at Server Mode.
We can now edit the values in PivotGrid and update a write enabled Cube at the back-end (SSAS) dynamically at runtime.
NOTE
Write-back is only supported for measures that use the SUM aggregation.
@Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("/OLAPService")).EnableCellEditing(true)
public Dictionary < string, object > WriteBack(string action, string value, string rowUniqueName, string columnUniqueName, string currentReport) {
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.SetCurrentReport(Syncfusion.JavaScript.Olap.Utils.DeserializeOlapReport(currentReport));
return htmlHelper.GetJsonData(action, DataManager, value, rowUniqueName, columnUniqueName);
}
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page