Slice Explorer

Opens the Slice Explorer

–

Refresh TM1 Servers

Refreshes the connection to TM1 servers

–

Upload Workbook

Uploads the workbook to the TM1 Server application folder

–

Calculate Sheet

Recalculates TM1 formulas on the active sheet

SHIFT+F9

Rebuild Active Form

Rebuilds the Active Form / Dynamic report on the active sheet

ALT+F9

Calculate All Sheets

Recalculates all sheets in the workbook

F9

Rebuild All Active Forms

Rebuilds all Active Forms in the workbook

–

Burst Report

Exports the report to single or multiple Excel/PDF files by cycling through a subset

–

Paste Range

Copies a set of values and pastes them over DBRW/DBR formulas to upload data to TM1

–

Refresh DBS

Refreshes DBS formulas that send data to the TM1 server

–

Remove TM1 Functions

Removes TM1 functions and converts them to values, retaining only Excel functions

–

Delete Active Form Rows

Deletes Active Form rows (sheet or workbook level)

–

Toggle Format Area

Shows or hides the Active Form format area

–

Add Action Button

Adds an Action Button to calculate the workbook, execute a process, or open a workbook from the TM1 application folder

–

Edit Action Button

Edits an existing Action Button

–

Upgrade Perspectives Buttons

Upgrades Perspectives action buttons for use in IBM Planning Analytics for Excel

–

Copy Button

Copies an existing selected button

–

Sandbox

Selects, creates, deletes, resets a sandbox, or commits sandbox data to the base

–

Statistics

Displays statistics about the file, including the number of TM1 formulas

–

Licence Type

Displays the current licence type

–

Settings

Sets the TM1 Server connection and features such as manual/auto calculation mode

–

Action Log

Shows a log of all actions taken by Slice

–

Version

Displays the current version of Slice

–