TM1: Default Formatting for Slice, Snapshot & Active Forms

The formatting of values within a TM1 cube view is handled by the attribute formatting of the measure dimension, however when taking a slice, snapshot or creating an active form from within a cube view the formatting is not retained in the excel output.

A simple, but counterintuitive solution is available within the TM1 cube view so each time you slice, snapshot or create an active form default formatting is present.

1. Open the cube within architect or server explorer (if using perspectives)

2. Set the dimension layout or select an existing view if appropriate

3. Select Options > Format


4. Choose the format you wish to use for your reports (ie. Comma with a precision of 2)


5. Select OK

6. If you want to override the existing view, press the save button and select Yes

7. If you want to save a new view, then select File > Save As and provide a name for the view

8. Now export your report using the Slice, Snapshot or Active Form

Please note the default formatting will only hold for the view that you have saved. Any other views will need to be updated individually.

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content