Write-back

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);
}