Wednesday, March 23, 2011

Does TM1 support clustering /load balancing?

Interesting link here about whether TM1 supports clustering/load balancing:


None of the shipped versions of the TM1 software support load balancing or clustering. The TM1 software does not possess any integrated load balancing or cluster functionality. Nor does it support and use load balancing or cluster standards and interfaces used by some external load balancing or clustering software.
For instance:
Cluster-aware software run by WCS (Windows Cluster Services) can execute a hot failover. If the master node of the WCS cluster fails, its slave node becomes the new master node. Cluster-aware software can directly switch from the failed old master node to the new master node. Due to the hot failover, from a user point of view nothing has happened, the user sessions survive the hot failover, the users are not forced to log on again after the switch of the cluster-aware application from the old failed master node to the new running master node.

But the TM1 Server software is not cluster-aware, thus it cannot perform a hot failover. In contrast to a cluster-aware application a non cluster-aware application must be started on the new master node. And because the user sessions have been terminated by the failure of the old master node, after the non cluster-aware application is up and running on the new master node, the users do have to log on again.

Tuesday, March 22, 2011

TM1 952 - New Rule and TI functions

The following link outlines the new rule and TI functions available in TM1 952.
The ability to do Averages in rules is something very exciting

Monday, March 07, 2011

TM1 Active Forms - hidden sheets

If you do an Active Form from the cube viewer and the row dimension does not contain a subset then it will create a hidden sheet in the workbook that contains a list of the elements you had in the rows.

Your TM1RptRow formula will then reference this hidden sheet with a formula similar to ({AR}01'!$B$17:$B$22)

These references to hidden objects perform slower on tm1web then references to subsets or mdx. For performance I would recommend replacing these hard coded references by changing the TM1RptRow formula to use the subset or mdx parameters and deleting the hidden sheet within the workbook

TM1 Active Forms

TM1 Active Forms are very powerful but sometimes a few simple tips can improve performance dramatically.
The next few post will outline a few of these simple techniques.

The first tip is that first row of the ‘active’ section is the basis of the entire report … all formulas are copied down from there. Find the row with the TM1RptRow formula and this is the row that will be copied.

You can actually delete all rows below row with the TM1RptRow formula. All rows beneath are calculated at run time.

For example I took a client's active form report, that was a simple active form straight from the cube viewer but contained nearly 1000 rows and took almost 5 minutes to appear on tm1web, deleted all the rows beneath the TM1RptRow then saved and uploaded. The result was the form then appeared in tm1web in seconds

Excel export not working in TM1 Contributor on Windows 2008

If exports are not working on your TM1 contributor deployment and you have installed on windows 2008 then its probably an issue outlined in the online manual about a chnage in dll locations in Win2008:

Due to a change in location of a Windows 2008 .dll file, when running TM1® Contributor on Microsoft® Windows 2008, you must either copy the .dll to the c:\windows\system32 location or add the following symbolic link to permit Export to Excel or Export to PDF to work.


Login to the system as an administrator. It is not sufficient to be a user who is part of the administrator group.

In a command prompt cd to


Enter the following command:

mklink iprop.dll c:\windows\syswow64\iprop.dll

This command creates a pointer to the original file required by TM1 Contributor.

If this link file is ever deleted, you must re-create the link to allow exports to work again

Thursday, March 03, 2011

Single Sign On for Cognos Express on Windows 2008

With the release of Cognos Express 95, windows 2008 64 bit is now a supported OS.

The following url contains notes to setup single sign on: