bw_get_query
Read a BW Query's full definition—variables, filters, layout, calculated/restricted measures, exceptions, and cells—including structure member planning settings. 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, position, nested child members and the inverse formulas that make an input-ready formula writable. 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.
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"). |