Exploring TM1

Great TM1 and Cognos content brought to you by Infocube

Discover More Here!

How to Rename a TM1 Model

Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName” Edit the value after the equals sign to reflect the new model name Save tm1s.cfg Open Cognos Configuration for TM1 Change the name of the TM1 Server Save Cognos Configuration Start the TM1 Server (right click, start) in Cognos Configuration … Continue Reading

How do Delete a TM1 Service

How to delete a redundant TM1 service from Windows. Sometimes we need to delete a TM1 service. After changing the name for a TM1 model, for example, we may be left with a Windows Service still existing for the old model. This explains how to remove a redundant TM1 server.

What is Skipcheck in TM1?

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only 9 of them, only 9 cells would be aggregated to get the total for the month. With the the skipping of blank cells disabled, all 30 cells would be checked to get the month total – three times more inefficient. … Continue Reading

AttrDelete TM1 Function: Syntax and Use

To delete an attribute in TM1 or Cognos Express during the execution of a Turbo Integrator process we use the AttrDelete function. Syntax of AttrDelete The syntax is: AttrDelete ( DimName, AttrName); where: DimName – is the name of the dimension that you want to delete an attribute AttrName – is the name of the new attribute you are deleting Example DimName = ‘Employees’; AttrDelete ( DimName, ‘Status’ ); Here we have defined a variable called DimName … Continue Reading

AttrInsert TM1 Function: Use and Sytax

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process. This function allows us to do that and create either a string, a numeric or an alias attribute. Syntax of AttrInsert The syntax is: AttrInsert ( DimName, PrevAttr, AttrName, Type ); where: DimName – is the name of the dimension that you want to create an attribute on PrevAttr – is the name … Continue Reading

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy!  Just use the pipe ( ” | ” ) between two variables and they will joined into one. There is nothing like the Excel Concatenate function in TM1. How to Concatenate Let’s say you have variable 1, sVariable1 = ‘Exploring’; and sVariable2 = ‘TM1’; then using sOutput = sVariable1 | sVariable2; will … Continue Reading

The Pick List – How to Create and Use Picklists in TM1

Using Picklists in TM1 is a great way of ensuring data quality. We explain different types of pick lists, why you use & how to create each type of pick list so you can have in cell drop downs active inside TM1.

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

In the rules for many cubes we work with there are conditional feeders. These often cause us problems where the evaluated value changes from a zero to a non-zero value and the fed cell does not get initiated and therefore the rule does not calculate. Background on Feeders As you would undoubtedly be aware, TM1 is an in memory application and extremely efficient with utilising that memory. It is also … Continue Reading

TI Connection Error to Cognos BI Report

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a client and it just makes sense to prepare the data in Framework Manager so it can then be used by any BI report and by TM1 as well. It especially cuts down reconciliation because if it is right in one … Continue Reading

Connecting to Alternative TM1 Server

If you’re like most of our clients you’ll have both a production and non-production environment for Cognos Express or TM1. It is not real obvious though how you switch servers from, say Production to Development, or Development to Test etc. Well here’s how you can easily change your TM1 login to point to a development, test or production server. Open TM1 Architect or Perspectives If in Perspectives (the Excel add … Continue Reading