bw_update_query_cells
Manage cell definitions in a two-structure BW Query by adding, updating, or removing reference, formula, and help cells at member intersections. All changes are applied in a single save.
Instructions
Manage the cell definitions of an existing BW Query that has two structures (one on each axis): add reference cells (make the value at an intersection of a member of each structure addressable), add formula cells at an intersection, add help cells (formula or selection cells outside the grid, used as reusable operands such as a unit-free denominator), change a cell's formula, description, decimals or scaling, and remove cells. Members and cells are addressed by description or id; bw_get_query lists the existing cells with the member descriptions they sit on. All operations are applied in a single save.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| transport | No | Transport request number (e.g. DEVK900123). Only needed when the query lives on a transportable package; omit for $TMP queries. | |
| operations | Yes | Cell changes, applied in order in one save cycle. A later operation can reference a cell an earlier one added, by its description. | |
| query_name | Yes | Technical name of the query to modify (e.g. "QUERY_NAME"). |