| title | Updating Cells (XMLA) | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| ms.custom | ||||||
| ms.date | 04/27/2017 | |||||
| ms.prod | sql-server-2014 | |||||
| ms.reviewer | ||||||
| ms.technology | analysis-services | |||||
| ms.topic | reference | |||||
| helpviewer_keywords |
|
|||||
| ms.assetid | a1c61496-36ee-4bce-98d9-d13440d349aa | |||||
| author | minewiskan | |||||
| ms.author | owend | |||||
| manager | craigg |
You can use the UpdateCells command to change the value of one or more cells in a cube enabled for cube writeback. [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] stores the updated information in a separate writeback table for each partition that contains cells to be updated.
Note
The UpdateCells command does not support allocations during cube writeback. To use allocated writeback, you should use the Statement command to send a Multidimensional Expressions (MDX) UPDATE statement. For more information, see UPDATE CUBE Statement (MDX).
The Cell property of the UpdateCells command contains the cells to be updated. You identify each cell in the Cell property using that cell's ordinal number. Conceptually, [!INCLUDEssASnoversion] numbers cells in a cube as if the cube were a p-dimensional array, where p is the number of axes. Cells are addressed in row-major order. The following illustration shows the formula for calculating the ordinal number of a cell.
Once you know a cell's ordinal number, you can indicate the intended value of the cell in the Value property of the Cell property.
Update Element (XMLA)
Developing with XMLA in Analysis Services