Skip to content

Rule Functions

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Now() TM1 Function: Syntax and Use

Posted on Sep 10, 2014 by John

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…

DIMIX TM1 Function: Use and Syntax

Posted on Sep 9, 2014 by John

DIMIX checks if an element exists in a dimension either as a primary element ID or as an Alias, and if so, returns the index value of the element. If…

DB TM1 Function: Use and Syntax

Posted on Sep 3, 2014 by John

The DB function returns the contents from a specific intersection in a TM1 cube (either string or numeric). It allows you to interrogate one TM1 cube from another and return…

NUMBR TM1 Function: Use and Syntax

Posted on Sep 3, 2014 by John

From time to time we need to convert a string (or text) into a value. If we were in Excel, we would use the Value function. Unfortunately, “Value” doesn’t work…

ATTRS TM1 Function: Use and Syntax within TI and Rules

Posted on Sep 3, 2014 by John

ATTRS stands for ATTRibute String, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Syntax of ATTRS The syntax is: ATTRS (dimension,…

ELISANC TM1 Function: Use and Syntax

Posted on Sep 3, 2014 by John

ELISANC stands for ELelemnt IS ANCestor, in other words, is one element in a dimension an ancestor of another. In other words, it is testing to see if one element is…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles