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

Harness the value of your data

We help organisations across Australia, New Zealand and South East Asia achieve better performance through business and technology solutions. Can we help you too?

Scroll to Top

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