Category Archives: Formatting
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
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.