Monthly Archives: February 2016

RIGHT TM1 Function: Use and Syntax

The RIGHT function from Excel does not exist in TM1. We need to use a combination of SUBST and LONG functions instead. Where you have a formula in Excel in A2 that is = LEFT ( A1, 4), where the contents of A1 is the string “ExploringTM1”, the formula will return the first 4 characters, i.e. “Expl”. To achieve the same result in a TM1 Turbo Integrator process we need to … Continue Reading

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink. | Leave a comment

LONG TM1 Function: Syntax and Use

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of LONG The syntax is LONG(string); where string is either the literal string to be evaluated or a variable that contains the string to be evaluated. Use An example of the use of it is as follows sString = ‘ExploringTM1’; LONG ( sString ); will return … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged LEN, LONG, SubSt. Bookmark the permalink. | Tagged LEN, LONG, SubSt | Leave a comment

LEFT TM1 Function: Use and Syntax

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a formula in Excel in A2 that is = LEFT ( A1, 4), where the contents of A1 is the string “ExploringTM1”, the formula will return the first 4 characters, i.e. “Expl”. To achieve the same result in a TM1 Turbo Integrator process we need to use the SUBST function. A … Continue Reading

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink. | Leave a comment

Limiting a Rule to Active Scenarios Only

Today I wanted to update a rule so that the processing of the rule was limited only to those scenarios that are “active”.  I could have gone through each line in the rules and added specific references to the scenarios I want to be active in the scope of each line of the rules. What I wanted was to limit rules to work only on specific scenarios. I then thought of this. If … Continue Reading

This entry was posted in Rule Examples, Rules. Bookmark the permalink. | Leave a comment

CubeClearData Syntax and Use

CubeClearData clears all of the data in a cube. It is a TurboIntegrator function, valid only in TurboIntegrator processes. This function is much faster than doing an operation such as creating a view to cover the entire cube, and then doing a ViewZeroOut() to zero out the entire cube, however it does not give you the flexibility to delete the data from a view or slice of a cube. When you use … Continue Reading

This entry was posted in TI Processes and tagged CubeClearData. Bookmark the permalink. | Tagged CubeClearData | Leave a comment