Data write-back to data provider from individual grid cells

Abstract

Architecture that provides an asymmetrical data approach to data write-back to a backend data store. Write-back is accomplished from a grid cell to a data provider (e.g., OLAP (online analytical processing)) that handles UPDATE CUBE statements. The coordinates of the data to access from the cube are provided in a first cell. In a second cell, the user provides the value desired to send back to the cube and a reference to the first cell that contains data value coordinates property. A calculation is triggered to determine if there is a difference in the value at the coordinates provided in the first cell and the user-supplied value in the second cell. If there is a difference, then the properties of the cube value function associated with the first cell are used to construct the UPDATE CUBE statement to send back the user-provided value to the data location defined by the coordinates.

Dependencies are inferred from the claim text.