Worksheets
From TM1 Cube Viewer, data can be sliced into Microsoft Excel for analysis and further presentation.
Slicing a view
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.
Snapshots
From TM1 Cube Viewer, data can be copied into Microsoft Excel for analysis ...
Get IBM Cognos TM1 Developer's Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
