bw_get_query
Reads a BW Query definition, including variables, filters, layout, measures, exceptions, and cell definitions. Falls back to inactive version if active not found.
Instructions
Read a BW Query definition — variables, filter, layout (rows/columns/free characteristics), calculated and restricted measures, exceptions, and cell definitions. Structure members are reported with their properties: input readiness and disaggregation (the planning settings), decimals, scaling, sign inversion, constant selection, the local calculation (results / single values as), exception aggregation, position, nested child members and the inverse formulas that make an input-ready formula writable. A member that shows a reusable CKF reports the CKF's own exception aggregation separately from the member's. Each variable lists where the query uses it — filter, default value, key date, structure member, formula, CKF/RKF, exception, condition, cell or text — or says that no use was found; the settings carry the key date (system date, a fixed date or a variable). Tries the active version first; falls back to the inactive version if not found. format="text" (default): compact human-readable output. format="raw": full parsed JSON.
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>"
},
"name": "bw_get_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | "text" (default): structured human-readable output. "raw": full parsed JSON. | |
| query_name | Yes | Technical name of the query (e.g. "QUERY_NAME"). |