| Anchor | ||||
|---|---|---|---|---|
|
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 level is year in time the Time dimension, you can drill into quarter, month or day level.
Try it yourself
| Info |
|---|
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 . |
| Anchor | ||||
|---|---|---|---|---|
|
Drill across will select member and show data across selected dimension.
Try it yourself
| Anchor | ||||
|---|---|---|---|---|
|
Drill through and Drill through cell show data which data are 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 consist consists of. These results can be exported in .csv an or .xls format.
Drill through
For Drill trough through you can choose, which measure to show - in Invoices cube it is Invoices, Items or Persons.
Try it yourself
| Info |
|---|
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. |