Which is a benefit of using query drill?

Query drill does not pre-fetch or store data for all levels - it is specifically designed to fetch data on demand at each drill step to avoid the overhead of loading all levels at once.

Query drill does not pre-format or store data for hierarchical levels; formatting is applied at render time, not pre-stored as part of query drill behavior.

When query drill is enabled, Web Intelligence generates a specific SQL statement targeted to the dimension level being drilled into each time the user drills, sending it directly to the database. This means only the data relevant to the current drill level is retrieved, keeping the document lightweight and allowing access to data not originally in the report's scope. This is in contrast to standard drill, which only pivots through data already fetched in the initial query.

Drill-through levels in query drill are determined by the universe hierarchy and the dimensions available in the query, not by the user's security profile.