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
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
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
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
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!
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
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
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
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
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
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
Keen to chat? Book a discovery call!