O'Reilly logo

IBM Cognos TM1 Developer's Certification Guide by James D. Miller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required