I need an example of what drill up/down is ( + if it's graphical ) for a better understanding of these operations. I'm new to the whole Data Warehouse subject so high level explanations would be appreciated.
The term is usually used in reporting. Here is a nice article with screenshots.