SSAS Cube Exploration: Digging Through the Details with Drillthrough

When exploring the data stored in a SQL Server Analysis Services (SSAS) cube, we sometimes need to know the details of the transactions that generated the information that we're visualizing. We need to go into the multidimensional model and execute a drillthrough operation to see the transactional details.

What's a drillthrough operation and how does it differ from other drill operations? This question can best be answered by looking at the four types of drill operations: