How to Create a New TM1 Server (Model)

Here are the instructions for setting up a new TM1 server (sometimes also known as a TM1 model). This can also be used for taking a copied TM1 model and setting it up on a new physical server.  The steps are: Copy the tm1s.cfg file from an existing model Change the ServerName, PortNumber, LoggingDirectory, and DatabaseDirectory within the copied tm1s.cfg to the name and location of the new server (model). Create a … Continue Reading

This entry was posted in TM1 Administration. Bookmark the permalink. | 1 Comment

How to Enable the TM1 Excel Addin and TM1 Perspectives Ribbon in Excel

I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon included in Excel. So I thought I would do a quick blog about how to enable it. What this does is then automatically add the Perspectives addin to Excel on your PC so that TM1 automatically opens each time you … Continue Reading

This entry was posted in Excel, Installation. Bookmark the permalink. | Leave a comment

ELLEV TM1 Function: Use and Syntax

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are interrogating, and element, is the element you want the level number for Use of ELLEV This function is used to determine the level of a specific element in a dimension.  It is often used in conjunction with an IF statement to … Continue Reading

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

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 it from being rolled up to the specified parent. For the opposite, please see DimensionElementComponentAdd. Syntax of DimensionElementComponentDelete The syntax is DimensionElementComponentDelete(DimName, ConsolidatedElName, ElName); where DimName, is the dimension you want to modify ConsolidatedElName, is the consolidated element you want to remove the … Continue Reading

This entry was posted in Elements, TI Functions. Bookmark the permalink. | 1 Comment

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 the dimension. The DimNm function looks up that index number and returns the element name corresponding to it. Syntax The syntax is DIMNM(dimension, index); where Dimension, is the dimension you want to interrogate. Note that if referring to a dimension … Continue Reading

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

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 number of elements (note that you may need to prefix the dimension name with the TM1 server name in the syntax servername:dimension). Use and Example You would typically use this function in to set up a loop so you can … Continue Reading

This entry was posted in Elements, Rule Functions, TI Functions and tagged DIMSIZ, WHILE. Bookmark the permalink. | Tagged DIMSIZ, WHILE | Leave a comment

AttrPutN TM1 Function: Use and Syntax

AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current element in a specified dimension. Note that this function does not insert a string into an attribute. To insert a string value into an attribute please see AttrPutS. Syntax of AttrPutN The syntax is AttrPutN(Value, DimName, ElName, AttrName, [LangLocaleCode] ); value, is the number that you want to insert dimname, is the dimension that you want … Continue Reading

This entry was posted in Attributes, TI Functions. Bookmark the permalink. | 2 Comments

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, yeah?  Just test if an element is there with a Dimix, then use a DimensionElementInsert and then an AttrPutS or AttrPutN to define the attribute.  Well, not quite. I had it all on the metadata tab, but even though the … Continue Reading

This entry was posted in Attributes, TI Errors. Bookmark the permalink. | 3 Comments

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 as a number.  To insert a numeric value into an attribute please see AttrPutN. Syntax of AttrPutS The syntax is AttrPutS(Value, DimName, ElName, AttrName, [LangLocaleCode] ); value, is the string that you want to insert dimname, is the dimension that you … Continue Reading

This entry was posted in Attributes, TI Functions. Bookmark the permalink. | 2 Comments

DimensionSortOrder TM1 Function: Use and Syntax

DimensionSortOrder is used to sort a dimension from within a Turbo Integrator (TI) process. Syntax of DimensionSortOrder DimensionSortOrder ( DimName , CompSortType , CompSortSense , ElSortType , ElSortSense); where: DimName, is the dimension to be sorted. CompSortType, sets the order for Consolidated elements. ByInput (the order used is the order the elements were added to the dimension) or ByName (the order used is alphabetic on the field chosen). CompSortSense, Ascending or Descending ElSortType, sets … Continue Reading

This entry was posted in Elements, TI Functions. Bookmark the permalink. | 1 Comment