Working with Slice in Excel

This section explains how to use Slice in Excel, covering the Ribbon toolbar, context menu, Active Forms, and Virtual Consolidations.

What You Will Learn

• How to use Slice in Excel

• The Slice Ribbon and its buttons

• The Slice context menu

• Active Forms with Dynamic Columns

• Virtual Consolidations

In this section

Slice Ribbon Toolbar Reference
A complete reference of every button on the Slice Ribbon — Explorer, calculate/rebuild, Paste Range, Remove TM1 Functions, sandboxes, action buttons, statistics and settings — including keyboard shortcuts and recalculation behaviour.

How to Create and Use Active Forms
How to build dynamic, expandable/collapsible reports from Excel or the cube view, write data back with Paste Range, and use the right-click context menu for Trace Rules, Drill Through, Annotations, and Cell Audit.

Active Forms with Dynamic Columns
Extends Active Forms so column consolidations can expand and collapse just like rows, with all standard Active Form features working identically.

Virtual Consolidations in SUBNM Formulas
How to combine multiple elements inside a SUBNM formula using arithmetic operators (the #3+5 syntax) without building a formal TM1 consolidation, including using Excel named ranges.

Insert Active Forms with Dynamic Columns
Step-by-step instructions for inserting a dynamic-column Active Form via the context menu, plus a breakdown of the TM1RptColumn function and its parameters.

Virtual Consolidations and Virtual Expressions
On-the-fly calculations executed by the TM1 server: Virtual Consolidations (# prefix) for arithmetic roll-ups and Virtual Expressions (## prefix) for MDX functions like AVG, MIN, MAX, and STDDEV.

5 Ways to Aggregate Data with Slice
An overview of five DBRW aggregation techniques — natural consolidations, subset references, virtual consolidations, virtual expressions, and cell range references — and when to use each.

Show and Hide the Slice Menu
A quick tip on using CTRL + SHIFT + M to toggle the Slice Explorer's left-side menu to maximise workspace.

Slice Excel Formulas
The full reference of Slice's Excel functions — from DBRW, DBR, and SUBNM to the TM1Rpt* Active Form functions and the ArcAssistant AI functions — with descriptions and parameters.

Converting Perspectives Action Buttons into Slice Buttons
How to use the built-in conversion tool to migrate Perspectives action buttons (single workbook or whole folder), including the Perspectives-installed prerequisite and required Excel macro settings.