TM1 Forum

We're in the process of getting the architecture for TM1 web approved internally and the server team are asking alot of questions that I don't know the answers to so I wondered if anyone here could help me?

I've read through the TM1 Operations Guide Manual and tried to extract as much info as possible but I think there are still some gaps (big holes!) in my knowledge. Our tm1 application server is running on a 64 server with 9.1.4 64 bit tm1.

1. Confirmation OS can be Windows Server 2003 IIS6 32 bit (NOT 64 bit) - I believe that this is fine
Confirmation Web Servers can be virtual Also that this is ok

2. Technical summary of connection string between web server and application server (inc. overview of web server configuration file specifying DNS alias of application server) From the documentation it looks like it uses HTTP and also that we can enter the admin host name into the web.config file to automatically direct clients to the correct admin host?

3. Technical summary of dynamic files necessary on web server created by Excel and overview of how a multiple web server farm running in an active/active configuration would be configured to replicate these files if necessary As I understand it c:\inetpub\wwwroot\TM1Web\ExcelSheet contains an xls and xml for each published workbook plus folders for css files. The server team are talking about using a shared web farm and were questioning whether this meant that those files would need to be replicated across the farm?

4. Technical summary of recommended security configuration for web clients inc SSL I believe that you can choose whether or not to use SSL but aside from that I'm not sure how you would configure it?

And finally they aren't happy about running Excel on a server, and definitely not on a shared farm, I've found a Technical Bulletin on the cognos site about how to run TM1 web without Excel but suspect that this may have all sorts of adverse affects to performance - does anyone have any experience of it?

I realise thats alot of questions but all advice would be very gratefully received!

Regards
Sarah
TM1 Developer
RBS Insurance

2. yes, change the following setting. web.config: <add key="AdminHostName" value="servername" />
you also can define the tm1server..
3. i think i would not replicate the content of the Excelsheet directory, but you can have a delay of a few seconds (~1-2s) because the files have to be generated every time. But at first, try it without replicating, if you have performance problems you can change it. Replicating is always a troublesome thing..
4. we use ssl encryption but i don't know what i should answer ..

regards
martin

Good that Martin E could help. But I would be looking for this kind of inner technical detail to be supplied by Cognos, either directly (if you are a direct client) or via your partner (if not). When you worked for a partner I'm sure that's what you would have said!
Were they no help?

1. 32bit OS should be fine. Our current TM1 Web server is using Windows Server 2003 SP2 32 bit & TM1(64bit) application server is using Windows Server 2003 SP2 64bit. Our TM1 Web Server is NOT virtual. Cognos should have supplied you with a recommended server specs.

regards

-Rod
TM1 9.1 SP3 / TM1web 9.1.3 / TM1 Executive Viewer 9.3
Testing 9.4 MR1

Thanks for all your replies guys

David U, Yes, of course as a Partner I would've expected a client to put those questions either directly to Cognos or through us but as a client now I realise that that can take some time so was looking for a faster route from all you knowledgeable chaps!

Regards
Sarah Horsted

I am implementing TM1 10.1. For the first time we are also splitting the web server. I thought I had issues with the path for the admin server, but I think I solved it. Below is my setup and please verify it looks ok.

One server, LRVTM101, I have everything but the Web running (installed). There are no issues with using TM1 with the client. Then I have another server, LRVTM1WEB01, that just has the Web installed. In the config file on the web server I put web.config: <add key="AdminHostName" value="http://LRVTM101" />

However my server name is blank. Would I need to point the TM1 server name to anything special, or can I leave it as below?

<add key="TM1ServerName" value="tm1serv" />

Are there any other port changes or something else that would need to be changed to get the tm1 server to display?

Thank you