How to use drill functionality in reports (Drill into, Drill through, Drill across)?

Drill into

Drill into can be used for a member of any dimension, that has several levels. Click on a member and select Drill into. It will show the next level of a member. 

This is useful, if you want to see all the levels of a measure, and if you are using Total function, so that values are not included twice.

Drill into level

If you want to drill into another level of the member, you can use Drill into level  functionality.

For example - if the level of the selected member is year in the Time dimension, you can drill into quarter, month or day level.

Try it yourself

Drill across

Drill across will select member and show data across selected dimension.

Try it yourself

Drill through cell

Drill through and Drill through cell show data that is imported from the register. This is useful in troubleshooting to see, if, for example, all of the invoices are imported - what the selected value consists of. These results can be exported in .csv or .xls format.

Drill through

For Drill through you can choose, which measure to show - in Invoices cube it is Invoices, Items or Persons.

Try it yourself