Product:
IBM Planning Analytics Local 2.1.9 tm1server = 11.8.02900.8
Microsoft Windows 2022 server
Issue:
How install PAL 2.1.9?
Solution:
Download the latest version from IBM
https://www.ibm.com/support/pages/node/7185721
Download only the Windows installation files from the different parts.
IBM Pafe x86 is for you if you have a 32 bit version of excel installed (this the most companies use)
IPA workspace win 2022 is the installation package for PAW for Windows 2022 server.
Before uninstall previous version, take a backup of changed files, like certificate store and samples in C:\Program Files\ibm\cognos\tm1_64\samples\tm1\ folder.
Unzip the packages to get the installation media out, and copy it to a folder on the server.
Run the install from file: analytics-installer-4.0.5-win.exe
Select language and click next
Click next
Click next
Verify the hard drive you are going to install to and click next
Click Yes
Click next
Click Install
Click done
To install the TM1 admin service, you must go to a CMD prompt, and move to the bin64 folder:
C:\Program Files\ibm\tm1_64\bin64 and enter command: Tm1admsd -install
Before you install the TM1 instances, check the tm1s.cfg file to have the correct values for: (some must be unique for each application)
IntegratedSecurityMode=5 UseSSL=T ServerName=Planning Sample DataBaseDirectory="d:\TM1Data\PlanSamp\data" LoggingDirectory="d:\TM1Data\PlanSamp\Logfiles" PortNumber=12345 HTTPPortNumber=12354 ServerCAMURI=http://caservername.domain.com:9300/p2pd/servlet/dispatch ClientCAMURI=http://caservername.domain.com/ibmcognos/bi/v1/disp
To install a instance to be in Windows service, enter:
tm1sd.exe -install -n "nameofapplication" -z "D:\TM1Data\SData\Config"
Where nameofapplication should be the same as you have entered as ServerName=nameofapplication
Think about the naming of the application will affect how it look in Windows services. Do not use non-english letters in the name.
Click on each TM1 service, and go to properties, and change the settings to Automatic. This to make them start when the server reboots.
To stop a TM1 instance, you have now go to Windows services and right click and select stop. Be aware that big TM1 instances, may crash during stop, and need to recover from log files when started.
If you have enter the wrong name, remove the TM1 instance with command tm1sd.exe -remove
Backup all TM1WEB configuration files, before doing any installation.
Run the installation of TM1WEB with file analytics-installer-3.7.37-win.exe
Select language and click next
Click next
Click next
Check the hard drive and click next (note; that tm1web install to the old folder)
Click yes
Click install
Click done
The service is automatic registered as: tm1web – right click and start all TM1 instances and TM1WEB.
You change the port tm1web are listen to in file : C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\server.xml
Default port is 9510.
You update tuning values in file : C:\Program Files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\configuration\tm1web_config.xml
Change the values, from your notes of previous installation, and save the file and restart the service.
When you get it to work – it should look like above. Browse to http://servername:9510/tm1web
The version of the installed TM1 program is now in other txt files than before.
(You must install PAW on a separate server, to be able to work with your TM1 instances.)
Please note that Planning Analytics for Microsoft Excel require that the client (laptop) have Microsoft .NET Framework 4.8 installed.
PAL 2.1.9 only support this versions of Windows server e.g. 2022.
PAW 2.1.9 demands Mirantis runtime on Windows to work.
On Linux there is other demands.
More Information:
https://endoflife.date/windows-server
https://exploringtm1.com/configure-planning-analytics-spreadsheet-services-ssl-certificate/
https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=web-configuring-browsers-cognos-tm1
https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=security-cognos
https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=security-configuring-tm1-web-use-cognos