11 Feb 20191 minute to read


This feature is applicable only for the OLAP data source at server mode.

You can edit the values in the pivot grid and update a write enabled cube at the back-end (SSAS) dynamically at runtime.


Write-back is supported only for measures that use the SUM aggregation.

  • JS
  • <ej:PivotGrid ID="PivotGrid1" runat="server" url="/PivotGridService" EnableCellEditing="true">
  • C#
  • public Dictionary < string, object > WriteBack(string action, string value, string rowUniqueName, string columnUniqueName, string currentReport) {
        OlapDataManager DataManager = new OlapDataManager(connectionString);
        DataManager.SetCurrentReport(Syncfusion.ASP NET.Olap.Utils.DeserializeOlapReport(currentReport));
        return htmlHelper.GetJsonData(action, DataManager, value, rowUniqueName, columnUniqueName);

    Write-back support in ASP NET pivot grid control