# Drill Into

{% hint style="info" %}
*Check-out the given walk-through on the Drill Into functionality.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FvvfzL125GgqDUNgx2uTy%2FDrill%20Into.mp4?alt=media&token=04cc0fa4-670a-4c58-8f2f-49148f0251fd>" %}
***Drill Into Functionality***
{% endembed %}

The ***Drill Into*** option allows users to drill down in the time values of a saved View on the selected report.

{% hint style="info" %}
*<mark style="color:green;">Pre-requisite:</mark> The user must define a hierarchical pattern among the date dimensions under the Data Center Module* *before using the Data Drill/ Drill into functionality in Report.*
{% endhint %}

## Defining the Hierarchy Drill for a Date Dimension <a href="#defining-the-hierarchy-drill-for-a-date-dimension" id="defining-the-hierarchy-drill-for-a-date-dimension"></a>

* Select an existing Data Store (or you can define the hierarchy while creating a new Data Store).
* Navigate to the ***Hierarchy Definition*** tab.
* Select a Date Dimension field.
* Click the add icon to add a new ***Drill Def*** space.
* Drag the selected Data Dimension to the ***Drill Def*** space (By default the dragged Date Dimension gets divided into 3 granularity levels).
* Click the ***Next*** option.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/OHrURnI3eyljxJ6Veozj/image.png" alt=""><figcaption><p><em><strong>Defining Hierarchy for a Date Dimension</strong></em></p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note</mark>: The user needs to **save** the Data Store with the defined hierarchy. Please refer the **Data Stores** section to know details on how to finish the Data Store creation.*
{% endhint %}

## Applying Drill Into Option

* Access the saved ***View*** from a report. Use the double-clicks to open it in the ***Analyse mode*** or Click the ***Analyse*** option for the saved ***View***.      ​

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/vlbbZDKuhKxkiIC3fvOS/image.png" alt=""><figcaption></figcaption></figure>

* The **Analyse** window opens displaying ***Year*** as the highest-level granularity of the date drill.
* Select the ***Drill Into*** option for drilling down the time-dimension.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/ExgXpOmYs4Sxu7uMw1Vv/image.png" alt=""><figcaption><p><em><strong>Years displayed as default display for the Drill Into option</strong></em></p></figcaption></figure>

* By clicking the ***Yearly*** granularity of the time value, the user gets the monthly value displayed in the selected view.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/IBFqGv0oj1iLvnAAfP5S/image.png" alt=""><figcaption><p><strong>Drilling down into a year to get data displaying months</strong></p></figcaption></figure>

* Click on the ***monthly*** granularity to display the exact dates of joining.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/XB4XqaOr1VT2XhpICkkk/image.png" alt=""><figcaption><p><em><strong>Drilling down into a month column to display dates-wise data</strong></em></p></figcaption></figure>