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.
                +1 
                A: 
                
                
              The term is usually used in reporting. Here is a nice article with screenshots.
                  Damir Sudarevic
                   2010-09-28 13:22:17
                
              Exactly what I needed, thanks!
                  Eton B.
                   2010-09-28 18:20:24