Uncategorized

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.

DimensionElementComponentDelete TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

DimensionElementComponentDelete selects a single element and deletes it from a consolidation element in a dimension in TM1. Importantly, it does not delete the element from the dimension itself, it only removes…

DimensionElementComponentDelete TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

DimensionElementComponentDelete selects a single element and deletes it from a consolidation element in a dimension in TM1. Importantly, it does not delete the element from the dimension itself, it only removes…

DIMNM TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element in a TM1 dimension has an index number.  This is internal to…

DimSiz TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DimSiz returns the total number of elements in a TM1 dimension. Syntax of DimSiz The syntax is DIMSIZ(dimension); where dimension is the dimension you want to get the total…

AttrPutS and AttrPutN Doesn’t Work!

Posted on Mar 19, 2015 by John

Attribute Definition Problem I just had an instance where I was adding new elements to a dimension in TM1 and then wanted to define an attribute for those new elements.  Easy,…

AttrPutS TM1 Function: Use and Syntax

Posted on Mar 18, 2015 by John

AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…

AttrPutS TM1 Function: Use and Syntax

Posted on Mar 18, 2015 by John

AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…

AttrPutS TM1 Function: Use and Syntax

Posted on Mar 18, 2015 by John

AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax

Posted on Mar 1, 2015 by John

The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a group of characters of  a specified…

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax

Posted on Mar 1, 2015 by John

The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a group of characters of  a specified…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles

Keen to chat? Book a discovery call!

pen