> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get Aggregates Query

> Reference for the `GetAggregatesQuery` query type in a DEE order, used to retrieve aggregate measure values for a specified `pivotId`, `locations`, and `measureSelections`.

## JSON Structure

```json theme={"languages":{"custom":["/engine/python-sdk/0.9/languages/pycon.tmLanguage.json"]}}
"queries": [
  {
    "@type": "GetAggregatesQuery",
    "pivotId": "Cube Name",
    "context": {
      "key": "value"
    },
    "locations": [
      "a|b|c|d",
      "dimension@level@hierarchy=[*];dimension@level@hierarchy=[*]"
    ],
    "measureSelections": [
      "measure1",
      "measure2"
    ]
  }
]
```

## Property Details

| Property          | Values                                                                                     | Default Value |
| ----------------- | ------------------------------------------------------------------------------------------ | ------------- |
| pivotId           | Name of Cube                                                                               |               |
| context           | Map - Context values                                                                       |               |
| locations         | List of String - [Location definitions](/user-guide/dee-orders#get-aggregates-query-order) |               |
| measureSelections | List of String - measure names                                                             |               |