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

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

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

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

CubeClearData TM1 Function Syntax and Use

CubeClearData: TM1 and Cognos Express command for clearing all data from a TM1 cube without deleting and recreating the cube. It does not give the flexibility of deleting the data from only a slice of a cube.

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */