Using TM1 Aliases in Cognos BI

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product ID’s or Customer Codes.  These are not particularly usable to most people, so we then usually create Aliases in TM1 as well.  Those aliases are visible through in Cognos BI.  Therefore when defining a dimension in TM1 when it is likely that it will be used in Cognos BI, also add an alias with … Continue Reading

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

Setting Up Level Names in TM1 for use in Cognos BI

I am in the middle of setting TM1 up for use with Cognos BI.  One of the things I like in BI is being able to present levels with business names rather than just level numbers.  To define these level names, open the control cube }HierarchyProperties and then orient it so that dimensions are listed as rows and HierarchyProperties are columns.  Then enter the default Member and the names to describe … Continue Reading

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a bunch of variables: sCurrentMonth = CellGetS ( ‘System Assumptions’, ‘No Year’, ‘No Month’, ‘Current Month’, ‘String’ ); sFileDir = ‘\\servername\folder\’; sFileName = sCurrentMonth | ‘ ‘ | SUBST(sCurrentYear,3,2) | ‘ Employees.csv’; sFilePath = sFileDir | sFileName; Then use DatasourceNameForServer and DatasourceNameForClient to … Continue Reading

This entry was posted in TI Data Sources, TI Functions, TI Processes and tagged CellGetS, DatasourceNameForClient, DatasourceNameForServer, SubSt. Bookmark the permalink. | Tagged CellGetS, DatasourceNameForClient, DatasourceNameForServer, SubSt | Leave a comment

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 and tagged ATTRS, ELLEV, ITEMSKIP. Bookmark the permalink. | Tagged ATTRS, ELLEV, ITEMSKIP | 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