One of the best features of TM1 is its ability to drill through a third-party database (e.g. Oracle Financials, SQL and MS Dynamics) from TM1 cubes, TM1 web sheets or MS Excel workbooks. With TM1, you do not to need to know SQL to access data from these databases. From TM1 you can simply on a cell where the drill is set up and drill either to another cube or to an external database.
Once you click drill, depending on how the drill is set up in TM1, you'll see either a cube view:
Or the details from the database: