Chapter 11. Using Drill

In this chapter, we will cover the following recipes:

  • Using the scope of analysis
  • Using a query drill
  • Using the drill formula

Introduction

What could be the simplest way to define what a drill is?

Drilling is a method that enables us to switch from an aggregative data display to a more detailed level of data, while keeping the data in the same context.

A straightforward answer for what keeps the data in the same context would be: the use of the relevant data hierarchy and determining whether it is a time, geographical, or product hierarchy. The hierarchy can also be costumed, and as long as the business user explores the data in a drill path that makes sense to him or her, it's only a matter of defining it.

For example, a business ...

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.