As specified in the TM1 Users Guide:
The Slice option, available from the Cube Viewer and In-Spreadsheet Browser, lets you save a cube view as a standard worksheet. When you create a slice, TM1 generates a worksheet populated with functions. These functions display the current database values in the worksheet.
As we mentioned earlier in this chapter, it is possible to drill-through to related data from a Microsoft Excel worksheet (rather than the TM1 Cube Viewer).
We can follow these steps to slice the current cube view into a worksheet:
At this point you should ...