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 selected member level is year in time dimension, you can drill into quarter, month or day level.
Try it yourself
Please note - if you would like to have all members in level you are drilling into - make sure that Hide Empty button is switched off. If it is not - you will see only those rows or columns that have values .
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 which data are imported from register. This is useful in troubleshooting to see, if, for example, all of the invoices are imported - what the selected value consist of. These results can be exported in csv an xls format.
Drill through
For Drill trough you can choose, which measure to show - in Invoices cube it is Invoices, Items or Persons.
Try it yourself
Drill through and Drill through cell can be used only on cells, but Drill into and Drill across can be used both on cells and on rows or columns.