Using a query drill
In general, the more dimensions and data we bring, the bigger the report gets, and the fetch time could get longer as well. The performance is of course a subject to changes as we are using in-memory and Big Data databases nowadays that can boost the performance of the queries.
When we are dealing with a drill, we need to take into consideration the performance and data volume and consider whether the extra dimension we require to drill through will result in another long refresh.
In order to optimize the drill performance in some cases, we can use the query drill option.
This option will "push" each value that we use in the drill filter bar into the query structure. For example, if we pick the month number 10 in the drill filter, ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
