Installing Cognos TM1 Perspectives

You can install IBM® Cognos® TM1® Perspectives, which is an add-in for Microsoft Excel.

Before you begin

Before you install IBM Cognos TM1 Perspectives, complete the following tasks:

  1. Install the software that is necessary for you to run Cognos TM1 Perspectives. For more information, see Install the prerequisite software.
  2. Ensure that the Cognos TM1 Admin Server and the Cognos TM1 Server that you want to connect to are running on an accessible computer in your network. For details, see TM1 Server installation.
  3. Ensure that users have access to the Cognos TM1 servers that they need to use running under that Cognos TM1 Admin Server. As a Cognos TM1 administrator, you must set up a user name and password for each user before a user can access that server.

About this task

The following steps install Cognos TM1 Perspectives on a single computer, configure it to locate a Cognos TM1 Administration Server on your network, and then connect to a server. You can also create an unattended installation.
Attention: If you are upgrading and leave your old Tm1p.ini client configuration files in place, you might need to update the directory path in the file for the AdminSvrSSLCertAuthority parameter. For example, if you are using the default Cognos TM1 SSL certificate, manually change the value for this parameter to the new install path C:\Program Files\IBM\cognos\tm1_64\bin64\ssl\applixca.pem.


  1. Install Cognos TM1 Perspectives:
    1. Right-click the issetup.exe file and click Run as Administrator.
    2. On the Component Selection page, expand TM1 Rich Tier, and select the TM1 Perspectives check box.

      Leave all the other check boxes unselected.

    3. Follow the prompts and click Finish to complete the installation.
  2. Run Cognos TM1 Perspectives:
    1. Click Start > IBM Cognos TM1 > Perspectives for MS Excel.
      If the component does not start, ensure that the servers you started with Cognos Configuration are still running.
    2. Click Enable Macros when the security warning displays.
  3. Configure Cognos TM1 Perspectives to locate a Cognos TM1 Admin Server:
    1. In Microsoft Excel, click TM1 > Options.
      The TM1 Options dialog box opens.
    2. In the Admin Host field, specify the name of the computer on which the Cognos TM1 Admin Server is running. If you want to access servers registered on different Admin Servers, use a semicolon to separate the name of each Admin Host. You must enter a name, not an IP address, in the Admin Host field.
    3. Click OK.
    4. When prompted about disconnecting from currently accessed servers, click Yes if you want to access a new list of servers. Servers available through Admin Server on the specified Admin Host appear. If you want to continue to see the current list of remote servers during this session, click No.
  4. Launch Server Explorer.
  5. Double-click a Cognos TM1 Server to log in.

    For either Planning Sample or SData, use these login credentials:

    • User name: admin
    • Password: apple
    Tip: To load Cognos TM1 Perspectives automatically whenever you start Microsoft Excel, add TM1_location/Tm1p.xla to Microsoft Excel's add-in tool list. The default location is C:\Program Files\IBM\cognos\tm1_64\bin64\. After completing this step, "TM1" displays on the Microsoft Excel menu bar.
  6. If you want to install Cognos TM1 Perspectives on multiple computers, use the previous steps to create an unattended installation that can. For details, see Setting up unattended installations and configurations.