execute_query
Run multi-dimensional analytical queries on discovered entities to compute measures, filter by dimensions, sort results, and apply date ranges for deeper data insights.
Instructions
Execute an Analytical Query. Perform multi-dimensional analysis on one of the entities discovered via 'discover_entities'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows to return (default None). | |
| order | No | Optional multi-column sort rules applied in order. | |
| total | No | Optional Cube total flag. | |
| offset | No | Optional row offset. | |
| filters | No | Optional filters to apply to the query. | |
| measures | No | Measures to calculate (e.g., ['Components.area']). MUST use 'Entity.Measure' format. | |
| rowLimit | No | Optional Cube rowLimit. | |
| segments | No | Optional Cube segments. | |
| timezone | No | Optional query timezone, for example 'UTC' or 'Asia/Shanghai'. | |
| ungrouped | No | Optional Cube ungrouped flag. | |
| dimensions | No | Dimensions to group/segment by (e.g., ['Components.id']). MUST use 'Entity.Dimension' format. | |
| renewQuery | No | Optional Cube renewQuery flag. | |
| entity_name | Yes | The name of the Entity to query (e.g., 'Components'). | |
| responseFormat | No | Optional Cube response format. | |
| timeDimensions | No | Optional Cube time dimensions. |