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 have a range of members that are sorted - please to drill into another level of the member, you can use Drill into level functionality like it is shown below
.
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
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 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
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. |