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 below:
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 through cell
Drill through