query_analytical_data
Execute OData queries on analytical models to retrieve aggregated data with dimensions and measures for business intelligence and reporting.
Instructions
Execute OData queries on analytical models to retrieve aggregated data with dimensions and measures. Supports full OData query syntax: $select (column selection), $filter (WHERE conditions), $orderby (sorting), $top/$skip (pagination), $apply (aggregations with sum/average/min/max/count/groupby). Perfect for business intelligence, reporting, and data analysis.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| space_id | Yes | Space identifier | |
| asset_id | Yes | Asset identifier | |
| entity_set | Yes | Entity set name to query | |
| select | No | Comma-separated list of dimensions/measures to return (OData $select) | |
| filter | No | OData filter expression (e.g., 'Amount gt 1000 and Currency eq "USD"') | |
| orderby | No | Sort order (e.g., 'Amount desc, TransactionDate asc') | |
| top | No | Maximum number of results (default: 50, max: 10000) | |
| skip | No | Number of results to skip for pagination | |
| count | No | Include total count in response | |
| apply | No | Aggregation transformations (e.g., 'groupby((Currency), aggregate(Amount with sum as TotalAmount))') |