Set Jedox Cell Value
jedox_set_cell_valueWrite a value to any cell in a Jedox cube with immediate persistence. Choose between SET, ADD, or ALLOCATE modes for handling consolidated parent cells.
Instructions
Write a value to a cell in a Jedox cube.
Cell writes are persisted immediately — no need to call jedox_save_database.
Args:
database_id: Numeric ID of the database
cube_id: Numeric ID of the cube
path: Array of element names, one per dimension in cube order
value: The value to write (number or string)
splash_mode: How to handle writes to consolidated/parent elements:
"SET" (default): Direct write; for base elements this always works
"ADD": Adds to existing value
"ALLOCATE": Proportionally distributes value to base-level cells
Returns: { success: true, path, value }
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | ||
| cube_id | Yes | ||
| path | Yes | One element name per cube dimension in order. Use jedox_get_cube to confirm dimension order. | |
| value | Yes | The value to write. Use a number for numeric cells, string for string cells. | |
| splash_mode | No | How to write to consolidated/parent cells: SET=overwrite (may fail for locked consolidated cells), ADD=add to existing value, ALLOCATE=distribute value proportionally down to base elements. For base-level elements always use SET. | SET |