Preparations for CXO Installation (Version 20) for TM1
This document describes the prerequisites and preparations for installing and configuring the CXO software as a dashboard on IBM Cognos TM1. It does not describe the installation and configuration itself.
The tables should be used as a check-list: either the indicated piece of information must be provided (enter it in the ‘Information’ column) or the specified action should be carried out / component should be installed (put a checkmark in the ‘Done’ column).
CXO Software Application Server
Provide the following information for the CXO software application server. We also support virtual servers.
Requirement / Action |
Information |
Done |
Windows 2012 / 2016 / 2019 |
|
|
Amount of RAM (min. 8GB, preferably 16GB) |
|
|
Check Disk Space available (> 25GB) |
|
|
Name (full DNS) |
|
|
IP |
|
|
Account to log on |
|
|
Domain (if applicable) |
|
|
Password1 |
|
|
SQL Server Management Studio installed (optional)2 |
|
|
Microsoft Components
The following Microsoft Components should be available on the server
Requirement / Action |
Information |
Done |
IIS 7 / IIS 8 / IIS 10 |
|
|
.NET Framework 4.8 (CXO installer will install it if it is not there yet, so there is no need to pre-install it) |
|
|
Service Account
For running the CXO software services and for the Identity of the Application Pools, we need a service account. This can be a local machine account or a Domain account. The password should never expire.
Requirement / Action |
Information |
Done |
Name |
|
|
Password |
|
|
Domain (if applicable) |
|
|
SQL Server
Meta-data of a CXO software application (reports, users, …) is stored in SQL Server databases. A SQL Server should be available, or otherwise SQL Server should be installed on the CXO software Application Server.
Requirement / Action |
Information |
Done |
Edition (Enterprise/ Standard / Express) |
|
|
Version ( 2012 / 2014 / 2016 / 2017 / 2019) |
|
|
Name Windows Server (full DSN) |
|
|
IP |
|
|
Instance name (or specific port)3 |
|
|
(Native) SQL Account (role = dbcreator4) |
|
|
Password |
|
|
Domain (or local) account to log-on to the server (optional: see3) |
|
|
Password |
|
|
TM1
CXO uses Rest API to connect to the TM1 application.
Make sure than the TM1 REST API is enabled on the server. See Enabling REST API on the TM1 Server below for more details.
Requirement / Action |
Information |
Done |
TM1 server with enabled REST API |
|
|
URL of the tm1 rest api. Make sure that the URL is accessible from the CXO Server |
|
|
UserName and password for rest API |
At this moment only authentication using username and password is supported |
|
Enabling REST API on the TM1 Server
Enable the TM1 REST API according to the IBM documentation:
Try to open the following URL in the browser to see if it works:
http://localhost:8989/api/v1/
https://localhost:8989/api/v1/
were 8989 is the port number specified as HTTPPortNumber