---
url: /excel-addin/cubeget.md
description: Retrieves data from a cube based on the intersection of elements.
---

# CubeGet

Retrieves data from a cube based on the intersection of elements.

See [FAQ](/excel-addin/faq#function-runtime-order) for details about function runtime ordering.

```js
CubeGet(applicationName, cube, ...elementNameN) 
```

#### Parameters

* `applicationName` - The name of the application through which to access the model.
* `cube` - The identifier of the cube.
* `elementName1` -  An element for each dimension within the cube which when used, finds a specific intersection.
* `elementName2` -  An element for each dimension within the cube which when used, finds a specific intersection.
* `elementNameN` -  An element for each dimension within the cube which when used, finds a specific intersection. `(optional)`

#### Example

```js
CubeGet("Performance Management", "General Ledger", "Actual", "2020", "Jan", "Revenue", "Marketing", "Amount")
```

This will return the value at the provided intersection for the cube "General Ledger".

## Using a hierarchy prefix

By default, an element is looked up in the dimension's default hierarchy. To use an element from another hierarchy, put the hierarchy name before the element, separated by the `»` [Hierarchy Prefix](/excel-addin/symbols#hierarchy-prefix):

```js
CubeGet("Sales Training Application", "Sales", 2020, "Actual", "All Customers", "Locations by Sales Region»Region A", "All Products", "All Sales Channels", "All Shipping Methods", "Revenue")
```

## Reading a CubeGet in a worksheet

In practice the arguments are cell references rather than literals, so one formula can be filled across a range and each cell resolves its own intersection.

![A CubeGet formula in a worksheet, with each argument colour-matched to the cell it reads - the scenario, year, department, measure and currency selections above the grid, and the account and month from the row and column headers](/excel-addin/cubeget-annotated.png)

The cell address is where the formula lives; the arguments are what it reads. In the example above:

* `"Planning Application"` - the [Application](/technical/about-applications) the model is accessed through
* `"Profit and Loss"` - the cube
* The remaining arguments point at the selections above the grid (`$B$7`-`$B$11`, absolute so they don't shift), plus the account from the row (`$A26`) and the month from the column header (`B$14`)

Mixing absolute and relative references this way is what lets a single formula be filled across the whole report: the selections stay pinned, while the account and month follow the cell.

::: tip Build the formula once
**Create Formula** on the [ribbon](/excel-addin/ribbon-overview) builds a CubeGet from the model structure rather than requiring the argument order to be typed by hand.
:::