What is a Drill-through action?

A drill-through action is a simple way to get to the bottom (leaf-level) details of your data structures within a data analysis session and presents an important self-service analytics tool for data in-depth exploration. Any business user can create drill-through actions with columns (attributes) defined at the moment of data analysis and does not have to be set up in advance by IT professionals. It could be used with SSAS OLAP cubes, Tabular model, or Kyubit Analytic Model data sources.

Set up a drill-through action in a few simple steps

The dynamic drill-through feature available in Kyubit's self-service analytics platform gives options for an analyst to select which columns from available dimension hierarchies will be returned in the list of detailed data (drill-through results) at the moment prior to drill-through action. A user is not limited by drill-through actions defined within the OLAP cube or Tabular model but can create any time within the analysis session. If those columns do not match requirements, the analyst can quickly edit and select a new set of columns to return in the drill-through action that would do the job required. The dynamic drill-through feature is available both in the self-service analytics grid and chart analysis.


Drill-through usage summary

Most of the time while analyzing multidimensional data, an analyst observes and analyzes aggregates of dimension members and hierarchies for some set of measures. At some point analyst is interested in more details in some aggregated information (cell), which would give an insight into detailed leaf-level information related to observed aggregated value, (typically presented by the value in some analytic grid cell or column/pie/point in the chart analysis.
Drill-through action could be saved for later usage and shared with other users.
A returned list of detailed data (drillthrough) results can be viewed and exported to an Excel file.
For more details on dynamic the drill-through feature, see the 'Drill-through section' in Self-service Analytics - user manual documentation.