> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/storyboard/data-interactions-data-drills/drill-into.md).

# Drill Into

This data drill allows the user to penetrate into deeper granularity level of the time dimension.

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

![Dill into functionality](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FSWAoxs1yHxjQd59dSJd0%2FDrillInto.gif?alt=media\&token=540b57c4-4af0-42c1-b7b5-61b76b4e78b5)

The Auto Data Drill allows users to drill down in the time values of a saved view on the storyboard for the selected story. 

{% 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 Story.
{% endhint %}

### Defining the Hierarchy Drill for a Date Dimension

* 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.

![Defining Hierarchy for a Date Dimension](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FrFh2Zxw936mFJwoGCbo5%2Fimage.png?alt=media\&token=4b776a86-fe04-4763-aa31-dbd18b49ae85)

{% 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 [<mark style="color:blue;">**Data Stores**</mark>](/bdb-documentation/data-center/data-stores.md) section to know details on how to finish the Data Store creation.
{% endhint %}

### Using the Drill Into option in the Story module

* Select the time dimension with the defined hierarchy drill and drag it to create a View.
* Click the **Save** icon to save the view on the Storyboard.

&#x20;    &#x20;

![Time Dimension based View](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FfqhxSKvzdmdapeM8Apnr%2Fimage.png?alt=media\&token=201b05a6-49d3-470f-99c1-f04faa82769d)

* Access the saved view on the Storyboard. Use the double-clicks to open it in the Analyse mode or Click the Analyse option for the saved View.

&#x20;     <img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FbzxRBcaYtRUSyCWdHMTc%2Fimage.png?alt=media&amp;token=1ac41d43-8fa1-462d-b99c-cc259367149a" alt="" data-size="original">

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

![Years displayed as default display for the Drill Into option ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FLiDzE9MJSWyCnxIRYst0%2Fimage.png?alt=media\&token=23020904-7ebb-4c5a-8d71-c001dfa7fe8f)

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

![Drilling down into a year to get data displaying months](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FQWSJ7iih8s9MmgFttUHA%2Fimage.png?alt=media\&token=a4ea78af-c1e0-4d6c-aea8-ce1542dff15d)

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

![Drilling down into a month column to display dates-wise data ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FuBPqJI5m9BGFOkHvqWIE%2Fimage.png?alt=media\&token=fa513580-8dfe-4cf4-b748-0db83a60a564)

&#x20;                                   &#x20;