bw_update_query_key_figures
Update BW Query key figure and characteristic structures in one save: add CKFs/RKFs, formulas, selections, member properties, restrictions, or remove members.
Instructions
Manage the key figure structure and the characteristic structure of an existing BW Query: add basic key figures, add references to reusable CKFs/RKFs (with optional local restrictions), add local formula members (recursive operator/operand tree), set member display and planning properties (decimals, scaling, hidden, sign inversion, input readiness, disaggregation, constant selection, local calculation) and exception aggregation, nest members and place them at a position, and remove members. Restrict members to hierarchy nodes or hierarchy node variables, replace a member's restrictions, and move all node restrictions from one hierarchy to another. All operations are applied in a single save. Member operations also apply to a reusable key figure structure referenced via bw_update_query_layout add_structure. All names must be technical names (e.g. "IOBJ_NAME", "CKF_NAME", "QUERY_NAME").
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query_name": "<query_name>",
"operations": "<operations>"
},
"name": "bw_update_query_key_figures"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| structure | No | Structure the operations address (default "key_figures"). "characteristics" is the second structure of a query, the one without key figures: add_structure creates it; add_selection, add_formula, remove_member, set_member_properties (e.g. hidden or position), set_member_restrictions and switch_hierarchy work on it. A formula there computes with members of that structure, constants and formula variables. | |
| transport | No | Transport request number (e.g. DEVK900123). Only needed when the query lives on a transportable package; omit for $TMP queries. | |
| operations | Yes | Key figure changes to apply in one save cycle. | |
| query_name | Yes | Technical name of the query to modify (e.g. "QUERY_NAME"). | |
| structure_target | No | Container for the key figure structure when it is created by the first add operation (default "columns"), and for the characteristic structure that add_structure creates. Ignored once the structure already exists. |