Access to Drill Through Reports
How you work with drill through reports depends on your level of access.
A user role of Database Manager is required to create drill through report definitions on a cube. If the drill through report definition is based on one or more Datasources defined at the application level, a prerequisite assumption is that a connection and Datasource were already defined at the application level, by at least an Application Manager.
The Application Manager who creates the connection and Datasource must additionally have appropriate credentials to access the external source system; for example, if the external source data is a SQL source, the Application Manager must have credentials to log in to the SQL source, in order to create the connection.
Power User is the minimum permission to create the application and cube in the first place. A Power User has implicit Application Manager permission for the applications he or she created, but not for all applications.
Any user with Database Access can access the drill through report, as long as the user’s filter does not restrict access to the cells within the drillable region defined for the drill through report. A drillable region is a specification that indicates the cell intersections from which the drill through report is accessible from Smart View.