query_analytical_data
Execute OData queries on analytical models to retrieve aggregated data with dimensions, measures, filters, sorting, and aggregations 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
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Maximum number of results (default: 50, max: 10000) | |
| skip | No | Number of results to skip for pagination | |
| apply | No | Aggregation transformations (e.g., 'groupby((Currency), aggregate(Amount with sum as TotalAmount))') | |
| count | No | Report a row count. Analytical entities declare Countable:false, so $count is not sent -- the count returned covers the current page only. | |
| filter | No | OData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Filtering a dimension is much cheaper than filtering an aggregated measure. Assets whose lineage includes federated sources accept only eq/and/or/(). | |
| select | No | Comma-separated list of dimensions/measures to return (OData $select) | |
| orderby | No | Sort order (e.g., 'Amount desc, TransactionDate asc') | |
| asset_id | Yes | Asset identifier | |
| space_id | Yes | Space identifier | |
| entity_set | Yes | Entity set name to query |