Drill Into

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

Check out the given walk-through on the Drill Into functionality.

Drill Into Functionalty

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

Pre-requisite: 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 the Report.

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

Please Note: To save the Data Store with the defined hierarchy. Please refer to the Data Store section for more details about the Datastore creation process.

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

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

View displaying the highest unit of Time (Year)

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

Drilling down into a year to get data displaying months

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

Drilling down into a month column to display dates-wise data