Rule Functions
ELPARN TM1 Function: How to Use and Syntax
ELPARN is a TM1 function for calculating the number of parents an element has. This includes the syntax and examples.
johnv
9-May-2024
ELPARN is a TM1 function for calculating the number of parents an element has. This includes the syntax and examples.
DimensionElementComponentAddDirect Function for use in TI Processes in TM1 and Planning Analytics to IMMEDIATELY consolidate (or rollup) elements in a dimension. Explanation with an example of use.
The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method
The INT function allows you to return the nearest integer less than or equal to a specified value. Syntax of INT The syntax of the INT function is simply: where:
The Max function will deliver to you the largest of two numbers. For example, if you have 50 and 100, using the MAX function will return 100. Syntax of MAX
Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an Excel file as the original
Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that!
The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’24-09-18′) will return the number 18.
Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site for DimensionDelete – but unfortunately that doesn’t exist. IBM, in their
A simple list of all the TM1 Turbo Integrator error codes and what they mean, listing the error, the severity and what it means.
Have you ever needed to just delete all elements from a dimension in TM1? Well there is a super easy function that does just this. Using DimensionDeleteAllElements, then one click
Full explanation of the Sleep function in TM1, with syntax and example so you can pause your Turbo Integrator process.
In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.
In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.
DimensionElementInsertDirect directly adds a new element to a TM1 dimension immediately – no need to wait for the end of the TI step.
ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.
‘@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.
ConsolidatedAvg is used to calculate the average of rolled up values at the consolidated level. Here it’s explained in detail with a worked rule example.
What is the fastest way to get data from one cube to another via a TI – is it use a view of the source and the CellPut functions to load it or is it faster to Extract and Load?
The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
