Using the TM1 Web Cube Viewer toolbar

The TM1® Web Cube Viewer toolbar buttons provide shortcuts to commonly used commands.

The following list describes each button in the toolbar.

TM1 Web Actions Menu button Actions menu
Provides access to common Cube Viewer tasks such as saving, closing, and exporting.
Save data changes icon Save data changes
Saves changes to your current data.
Save view icon Save view
Saves the current view to the TM1 server.
Save as icon Save as
Saves the current cube view with a new name.
Export icon Export
Exports Cube Viewer data in the following formats:

Slice to Excel icon Slice to Excel - Exports Cube Viewer data and TM1 formulas (SUBNM and DBRW functions) to a new Excel spreadsheet. The spreadsheet maintains a connection with the TM1 server.

Snapshot to Excel icon Snapshot to Excel - Exports only Cube Viewer data to a new Excel spreadsheet, excluding the TM1 server formulas (SUBNM and DBRW functions). The spreadsheet does not maintain a connection with the TM1 server.

Export to PDF icon Export to PDF - Exports the Cube Viewer data to a PDF file. You must install a PostScript printer during the TM1 Web installation for the Export to PDF option to work. For more information, see the Planning Analytics Installation and Configuration documentation.

For more information on generating reports from a TM1 Web Cube Viewer, see Generating a report from a Cube View.

Reset data icon Reset data
Clears all the changed data values that you entered up to that point in a sandbox. Resets all the data values back to the current values in the base data.
Reset view icon Reset view
Reloads the visual appearance of the Cube Viewer to the last saved arrangement of title dimensions.
Close
Closes the currently selected cube view.
Close others
Closes all cube views, except the currently selected view.
Close all
Closes all cube views.
Submit Data Changes icon Commit
Sends the changes you make to data in the Cube Viewer to the TM1 server.
Recalculate icon Recalculate
Updates the Cube Viewer configuration and recalculates data in the view. If you have edited any cells, all edits are automatically submitted to the TM1 server.
Auto Calculation icon Auto calculation
With the Auto Calculation option turned off, TM1 Web does not automatically recalculate the Cube Viewer when the view configuration changes.

For example, if you edit a row subset or move a dimension from the titles to the columns, these changes are not immediately displayed in the Cube Viewer; you must click the Recalculate button to see your changes.

When the Auto Calculation option is turned on, TM1 Web automatically recalculates the Cube Viewer when the view configuration changes.

Suppress Zeros icon Suppress zeros
There are three options to suppress zeros:
  • Suppresses zeros in rows and columns
  • Suppresses zeros in rows
  • Suppresses zeros in columns
View chart icon View chart
Displays the Cube Viewer data in a chart format.
View chart and grid icon View chart and grid
Displays the Cube Viewer data in both grid and chart formats.
View grid icon View grid
Displays the Cube Viewer data in a grid format.
Chart properties icon Chart Properties
Displays options for selecting chart type.