---
title: "Drilldown"
method: GET
path: "/cube/drilldown"
tags: ["Drilldown"]
---

# Drilldown

`GET /cube/drilldown`

This endpoint retrieves any values in the cube that make up the overall value at the provided
cross section of dimensions. For instance, in the example JSON "Q1-19" was provided as the "Time" dimension and
you can see that it returned a value for "Jan-19", "Feb-19", and "Mar-19" which all make up "Q1-19".

Drilling down into a cube value is very similar to viewing details for a value, and filtering in that you are able
to pass either the names of the dimensions or their IDs as parameters. A dimension value must be provided for each top
level dimension.

The drilldown endpoint supports other currencies as long as the company has the alternate currency enabled.

## Query parameters

- `Account` string[]
- `Department` string[]
- `Scenario` string[]
- `Time` string[]
- `currency_code` string
- `export` '' | 'CSV' | 'XLSX'
- `full_path` boolean
- `include_zeroes` boolean
- `limit` integer
- `spreadsheet` boolean

## Headers

- `X-Company-ID` string, required

## Response `200`

- CubeDrilldownResponse
  - `id` string, required
  - `value` string, required
  - `formula` object, required
  - `calculated` boolean, required
  - `dimensions` object, required
  - `attributes` object, required
  - `splits` unknown[], required
    - unknown

---

[API](https://skmtc.net/cubesoftware/apis/cube-api.md) · [All operations](https://skmtc.net/cubesoftware/apis/cube-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cubesoftware/cube-api/revisions/67d9f45bb99b/schema)