Category Archives: Formatting

Formatting a Cube to Display Thousands

I opened a cube the other day that had been created by someone else and was confounded for a short while about how it was formatted to display thousands, rather than units. Select the Measures¬†Dimension, then tight click and Edit Element Attributes. Select the element you want to set, click the format button, choose Custom and paste #,###,;(#,###,) into the Custom Style. ¬†This will then remove the last three digits … Continue Reading

3 Types of Rules TM1 Developers Should Know

In this blog we discuss how to do three different rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There is full explanations and the code used for the rule examples.