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.