Drill Through in Views Accessed Via SpotlightXL or Spotlight Honor Group Access for ESMs

If a user has access to an Analytic model view that is populated via an ESM model, but has no access to that ESM, the user will not be able to drill through the data.

Drill-Through provides a way for users to see all the data points that were aggregated to form a particular data cell. When data is loaded via an ESM, transaction data is aggregated into analytic data.
Drill-Through provides visibility into rolled up data in two ways:

• From parents whose children are present in the model.
• From parents whose children are absent in the model.

The first image below shows a view and the Drill Through icon in the ribbon. The second image displays the DrillThrough tab that appears once you click Drill Through.