From TM1 Cube Viewer, data can be sliced into Microsoft Excel for analysis and further presentation.
To slice a view from Cube Viewer to an Excel worksheet, you can click on File and then select Slice. TM1 will copy the current view into a new MS Excel workbook. Sliced views are still connected to TM1, because TM1 adds the appropriate TM1 functions to the worksheet to retrieve the data from the cube. The workbook can be saved, reopened later, and, as long as you are logged into the TM1 instance, the latest cube data can be viewed from within the workbook. All of the cell formatting available in MS Excel can be used to further format the data.
From TM1 Cube Viewer, data can be copied into Microsoft Excel for analysis and further presentation. In contrast to the slice, the snapshot is a copy of the data at that moment in time. No TM1 connections are added to the worksheet and data cannot be automatically refreshed or recalculated at a later time but all of...