Write Back in JQuery PivotGrid widget

13 Feb 20191 minute to read

IMPORTANT

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

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

NOTE

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

  • js
  • $(function() {
        $("#PivotGrid1").ejPivotGrid({
            ...
            ...
            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.JavaScript.Olap.Utils.DeserializeOlapReport(currentReport));
        return htmlHelper.GetJsonData(action, DataManager, value, rowUniqueName, columnUniqueName);
    }

    Write-back support in JavaScript pivot grid control