---
schema_version: "1"
id: ca7dd9a8074e44c14977ce4631ea1de2eb9bd1076938bcd2b4df4dfcfb1ac06b
title: Drilling Down and Up in a Cube Data Source Hierarchy
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/pro/desktop/buildmanual_multidimensional_drilldown.md
canonical_url: https://help.tableau.com/v0.0/pro/desktop/en-gb/buildmanual_multidimensional_drilldown.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 9a48887de04a755ebe600c19144851a164fd2a8b39281fa53d62fb4c658f2b5d
description: Drill up and down through cube data source hierarchies to navigate levels of detail.
---
[Skip to main content](#main-content)

# Drilling Down and Up in a Cube Data Source Hierarchy

**Note**: The following applies only to certain multidimensional data sources.

Multidimensional (cube) data sources contain hierarchies. One of the most useful ways to navigate hierarchies is to drill down or drill up. For example, if you are examining the sales totals for various years, you can then drill down and view sales for all of the months within each year. Alternatively, if you are examining sales totals for all months, you can then drill up and view the sales for each year.

## Hierarchies in cube data sources

**When connected to cube data sources, you cannot create or customise hierarchies in Tableau**. Hierarchies must be created in the cube **before** you connect to it in Tableau.

Hierarchies appear with the following icon in the Data pane: ![cube\_hierarchy1.png](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy1.png)

You can see an example of a hierarchy below:

![Expanded Product Category hierarchy with product categories, subcategories and product names.](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy2.1.png)

**Note**: You can only drill up or down in fields that are part of a hierarchy.

## Drill up and down for **all** dimension members in a hierarchy

To drill up or down for all dimension members in a hierarchy:

- On the Columns or Rows shelf, or the Marks card, click the plus sign (+) on a field to drill down, or the minus sign (-) to drill up.
    
    ![ Drill up or down for all dimension members in a hierarchy.](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy5.gif)

## Drill up and down for **individual** dimension members in a hierarchy

To drill down and drill up for individual dimension members in a hierarchy:

- Right-click a table header and select Drill Down or Drill Up .
    
    ![Drill down and drill up for individual dimension members in a hierarchy.](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy6.gif)
    
    This is often referred to as non-uniform drill down because you expose only the members of interest instead of exposing all the members of a given level.
    
    For example, you can see the difference between drilling down for all dimension members and drilling down for individual dimension members below.
    
    **Individual dimension member: Bikes**
    
    ![A table displaying sales amounts categorised by product categories and subcategories.](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy3.png)
    
    **All dimension members**
    
    ![A table showing sales amounts categorised by product subcategories.](/tableau/next/en-gb/pro/desktop/en-gb/Img/cube_hierarchy4.png)

One reason to use a non-uniform drill down is if your data source has a ragged hierarchy (asymmetric layout). You also might want to view the children for just the member of interest.

**Note**: Drilling down and drilling up results in filtering the data.