/
💡 Slice Insights

💡 Slice Insights

Additional Resources and Tips

Further Learning

The following articles provide additional guidance on getting the most out of Slice:

Getting Started

Cube Viewer and Subset Editor

Hierarchies

Advanced Report Types

Quick Reference: Keyboard Shortcuts

Action

Shortcut

Action

Shortcut

Calculate active sheet

SHIFT+F9

Rebuild Active Form on active sheet

ALT+F9

Calculate all sheets

F9

Quick Reference: Hierarchy Formula Syntax

Formula

Syntax Pattern

Formula

Syntax Pattern

SUBNM

=SUBNM("Server:Dimension:Hierarchy","Subset","ElementID","Alias")

DBHW

=DBHW(ViewRef,"Dimension:Hierarchy",CellRef,...)

TM1RptRow

=TM1RptRow($B$9,"Server:Dimension:Hierarchy",...)

TM1RptCol

=TM1RptCol($B$9,"Server:Dimension:Hierarchy",...)