Drilling

Overview

To access different subsections of data Saiku has two “Drilling” Methods Drill Through Drill through allows you to pick a cell and see the raw data that makes up the value of the measure you are looking at. For example:

First I select the drill through function by clicking on its icon.

Then I select the cell I am interested in on the result. In this example I have selected the Deluxe Supermarket row. I’ve then decided I want all the available information returned to me.

When I click okay, the output Saiku then shows me a table with the row level data, in this case a breakdown of the rows which made up the Deluxe Supermarket cell. Drill Across Drill across is a useful feature that allows users to find out more about a specific area of a query for example:

I click on the drill across icon.

In this sample query I have the total yards gained by USC and I want to know more about how they got them. I could rearrange the query by moving elements around or I could click on drill across. In this example I want to know the away team code and the Yards gained and Touchdowns scored, so I check those boxes and press ok.

When the query is executed, you can see that my Team Name level that was on Rows is now in the filter. Away Team Name has been moved to Rows and Touchdowns added to the measures. This then gives me the breakdown of the yardage and touchdowns scored by away team against USC.