TM1 and Citrix

[George Regateiro]

We are implementing Citrix for all the obvious reason for TM1 over the WAN, but I was asked some questions that I have not been able to find any answers to on the wonderful IBM site so I thought I would ask them here.

1) Is Citrix an officially supported distribution platform for TM1? I searched the docs and came up with nothing.

The following questions hinge on number 1

2) Are there any docs relating to requirements to deploy tm1 over citrix and/or best practices? Specifically my network folks wanted to know if there was any breakdown of how TM1 utilizes the ICA channels for tweaking purposes.

3) If Citrix is not officially supported have there been any issues related to deploying TM1 in that environment?

Thanks for any help that can be provided.

[DFranken]

Hi George

I ran a search through my archive and found there references:

"Supported but untested Cognos does not actively test the releases with the software listed below, however, we are not aware of any technical issues that would prevent the software from working properly. Should an issue arise within these environments, Cognos will make a
best effort to fix it.)
Third Party Software
TM1 Client running under Citrix"

Page 40 of the 9.4 Operations Manual:

"In some particular situations, most notably running TM1
clients under a Citrix environment, the response from the
client application never arrives back at the TM1 server,
causing the server to wait for an infinite amount of time."

I have seen a case study of New Zealand Post and Prenco that use or used Citrix.

cognos_pp_performance_tm1_deployment_options_and_bandwidth_considerations.pdf

"TM1 Add-In for Microsoft Excel Deployed over screen remoting technology (i.e. Citrix, Microsoft RDC)

Functionally identical to Standard TM1 Add-In above.
Enables application administrators to centralize
presentation workbooks on a server, which can improve
performance for users with low desktop power and/or lowbandwidth
connections.
"

You can also look at: http://www.tm1-tipz.blogspot.com/2008/0 ... ction.html

Hope this help.

[George Regateiro]

Thanks I will look the links over.

Also thanks letting me see that the Windows Live Search needs some tweaking since it is supposed to be indexing the TM1 manuals, but when I ran the searches on my own desktop nothing is retrieved.

[RLReyes]

George,
I'm not sure if Citrix is officially supported. When we selected TM1, we had Applix folks help us implement the product over Citrix. It has been over 3 years now & we haven't had any major issues TM1 over Citrix.

[Martin Ryan]

We use it (worldwide bank) and have had very very few issues with Citrix, especially in comparison with the issues we've had with TM1 itself. I cringe to think how performance would be if we didn't have it.

Martin

[hbell]

We've been using Citrix with TM1 at American Express for about a year now. We have around 1000 (spread around the world) users and 8 citrix servers. We set the Citrix servers up on VMWare and are starting to see issues with maxing out the processors causing irritating delay for the users. I suspect we will be forced back to a more physical set up, but our Tech folks are reviewing the moment.

hugh

[Railroader]

We've used Citrix with 9.0 sp3 and 9.4 MR1 FP1. We have experienced issues where manual calculation does not stay set as a default once set for users with Excel 2007 and Citrix. We can workaround setting manual calculation in VBA when the workbook opens, but have not had success as a default setting.

[Martin Erlmoser]

We've used Citrix with 9.0 sp3 and 9.4 MR1 FP1. We have experienced issues where manual calculation does not stay set as a default once set for users with Excel 2007 and Citrix. We can workaround setting manual calculation in VBA when the workbook opens, but have not had success as a default setting.

save a blank sheet in %appdata%\microsoft\office\xlsstart with the setting
multithreading = off & calc mode = manual

should work..