Drilling Level
This operation can be considered as a special case of "List of elements selection", in which all the elements of a given level are queried.
To check all elements in a level follow these steps:
- Choose the "Drill Level" option from the list of available operations.
- The control panel shows the different levels of hierarchy of the dimension. You must select the desired level, by double-clicking on the element or choosing the check-box and pressing the "OK" button.
Picture 5: Example on how to view a whole level
Example
The previous picture shows the selection of the "Quarter" level in the "Date" dimension. The result of that query (if the dimension is located on one of the axes) is the list of quarters of all the years for which there are data in the cube.