Monthly Archives: September 2014
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use a combination of attributes and ATTRS rather than this function. Please see our warning below. Syntax The syntax is: ELPAR(dimension, element, index), where: dimension is a valid dimension name, and element is the name of an element within the dimension or … Continue Reading
Ever wanted to create a command similar to an SQL “IS IN” in a TM1 Turbo Integrator process? Or use operators in a TM1 TI process to create a “NOT IN” like command from a SQL? Or wanted to use an OR, an AND or a NOT EQUAL TO command in a TI process? Well, you can. If you are looking for the operators to use in a TM1 Rule, please check … Continue Reading
A <set> in an MDX expression in TM1 refers to a group of elements. Usually in TM1, this would be a subset in a dimension, although note that not all subsets are created by MDX. So when using <set> in an MDX statement, usually you will refer to a subset of a dimension.
MDX in TM1 leverages of the standard MDX language (note leverages off, not uses). It is an industry standard query language for multi dimensional analysis. TM1 does not support the entire language and also adds on TM1 relevant features as well. Keeping Dimension Subsets Up to Date In a dimension, a great way to keep a subset up to date is to use MDX. To do this enable the view of the … Continue Reading
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
These are the steps I have just used to create my first TM1 Contributor model. There are more steps here than in Performance Modeller, however I think this more complete list is more useful. Step 1 – Build Views and Websheets Build the Excel Websheets and TM1 Views you want to include in the Contributor model. Note that all websheets and views must have the dimension you have defined for … Continue Reading
The Now function returns the current date-time stamp from the TM1 server Syntax of Now The syntax is Now(); There are no arguments. Usage of Now Typically Now(); will be used to store the current time in a numeric variable and then this will be addressed through other functions. For example nTimeNow = Now(); will store the current date-time stamp from the server in the variable nTimeNow. Now() can be used … Continue Reading
You can’t do spreading from a rule driven intersection – it must be from a value that has a natural hierarchy. So I tried to zero All Years from Current Forecast where I have a rule driving Actuals into historic periods in the forecast and I got an error saying the “Spreading operation has failed because the content of the cells cannot be modified”.
In TM1, what’s the easy way to zero all the values in a cube, or all the child values of a parent? Easy, open the cube in Architect, navigate to the total you want to clear out and press “C”.You’ll then be asked if you want to perform a ‘Clear’ operation. Say yes and Zap. Gone. All zeros. Too easy! Just as an aside, you can’t do it to an intersection … Continue Reading