Installing TM1 Web

Installing and Running IBM Cognos TM1 Web:
Before you install the IBM Cognos TM1 Web software, you need to understand about the software requirements:

● Software Requirements
● Installing the IBM Cognos TM1 Web Software

Software Requirements:

Operating System	Microsoft Windows
Web server	Microsoft IIS
Microsoft Excel	Excel 2002 or later
Web browser	Microsoft Internet Explorer
Windows Service Account	Windows services run under a network user name and password. We recommend that you establish a user account and password in your network exclusively for the IBM Cognos TM1 Web services. The account can have any name.

Installing the IBM Cognos TM1 Web Software:
Follow these steps to install IBM Cognos TM1 Web.

Steps:

1. Insert the TM1 distribution CD in the CD-ROM drive.
   The Installation Wizard runs.
2. Click IBM Cognos TM1 Web, and click Install.
3. Select a language: English, French or German. Click OK.
   The Installation Wizard Welcome screen opens.
4. Follow the wizard instructions to install IBM Cognos TM1 Web.

TM1 Web Architecture

IBM Cognos TM1 Web Overview:

IBM Cognos TM1 Web extends the analytical power of TM1 by allowing you to complete the following tasks in a Web browser:

● Analyze cube data
● Manipulate formatted Excel reports
● Drill, pivot, select, and filter data
● Build charts
● Perform some server administration tasks

IBM Cognos TM1 Web Architecture:
The IBM Cognos TM1 Web multi-tiered architecture includes an IIS Web server, an Excel Web service for displaying Websheets, a TM1 server, and an Admin server.

Note: IBM Cognos TM1 Web requires the Microsoft .NET Framework.

IIS:

1. The IIS Web server has a virtual directory that stores TM1 Web ASP scripts.
2. IIS Web server must have Microsoft Excel 2002 or later versions installed. This software is required to generate TM1 Websheets.
3. IIS Web server must have Microsoft.NET Framework version 3.0 installed.
4. Web installs a Windows service – the TM1 Excel Service (TM1ExcelService.exe) on your Web server. This service converts Excel worksheets to TM1 Websheets. It also exports Websheets back to Excel or to PDF.

TM1 Server and TM1 Admin Server:

1. TM1 Server can be installed on the same computer that hosts your Web server, but installing on a separate computer is more efficient.
2. TM1 Admin Server can be installed on any computer on your LAN, but it must reside in the same LAN segment as your TM1 Server. Typically the TM1 Server and the TM1 Admin Server are installed on the same computer.

Monitoring TM1 server performance

Monitoring Server Performance:
TM1 includes a performance monitoring feature that lets you record the performance statistics for clients, cubes, and servers. When you enable performance monitoring, TM1 populates several control cubes on a minute-by-minute basis. You can then browse these cubes to analyze the server performance.

The following control cubes are populated during performance monitoring.

1. }StatsByClient
2. }StatsByCube
3. }StatsByCubeByClient
4. }StatsForServer

}StatsByClient	Tracks the message count, average message size, total elapsed time, and other measures for each client on the server.
}StatsByCube	Tracks the memory used for each cube on the server.
}StatsByCubeByClient	Tracks the number and elapsed time of cell updates, cell retrievals, view calculations, and view retrievals for each client and cube on the server.
}StatsForServer	Tracks the connected clients, active threads, and memory used by the server.

Steps:

1. Select the server in Server Explorer.
2. Click Server, Start Performance Monitor.
   You have enabled performance monitoring on a per-session basis.
   If you want to enable performance monitoring at the start of every server session, you can set the "PerformanceMonitorOn" parameter in the Tm1s.cfg file to automatically begin performance monitoring when a server starts.
   To end performance monitoring during a server session:
3. Select the server in Server Explorer.
4. Click Server, "Stop Performance Monitor".