You can download the stand-alone Controller client.
Notes:
The installation of the standalone Controller client will also install the Excel link.
The Excel link is provided in 64-bit format and can be installed only on computers with a 64-bit operating system and a 64-bit version of Microsoft Office. 32-bit versions are not supported.
Ensure that your computer meets each of these prerequisites:
You uninstalled Controller excel link.
You installed Microsoft Excel for Microsoft 365.
You installed Microsoft Edge Runtime.
You are logged into Microsoft account.
You installed Microsoft .Net 4.8
Note: .NET Framework 4.8 is included by default in Windows 10 Version 1903 and newer. For earlier versions of Windows OS, you must manually install .NET Framework 4.8 from the official Microsoft download page.
In a browser window, log in to Controller Web.
Download the installer:
On the landing page, click the User icon .
From the User list, click Controller Client.
In the Controller Client License Information window, select I agree to proceed.
Install the Controller Client:
Proceed with the following steps:
Open the Downloads folder or the directory where the ZIP file was saved.
Unzip the downloaded .zip file to a preferred location on your computer.
Note: Always unzip the installation file into a newly created, empty folder. If you unzip it into a folder that already contains other files, all contents of that folder may be deleted during the uninstallation process.
Inside the extracted folder, double-click the client.bat file to execute the client setup.
When prompted, for the WSS URL, enter https://your_controller_server/ibmcognos/controllerserver and click Enter.
Open the Controller Client.
Note: Make sure you are logged into Controller Classic before accessing Excel client.
Proceed with the following steps:
Navigate to the CCRRemoteClient64.zip extracted folder
Double-click CCR.exe to start the application.
Select the database.
Enter your Username and Password, and then click Login.
Important: It may take a minute or two for the login to finish. Do not click in Controller or navigate to another application during this time.
Results
You should now be able to connect to IBM® Controller.
Note: If you cannot connect to Controller Client, it may be related to an incorrect registry setting. If you continue to experience an issue with your Controller Client installation, uninstall it completely, and then reinstall it.
For native TM1 access, ensure the HTTPPortNumber are set in tm1s.cfg for your applications. If you use Admin with password apple, ensure that account exist in all your TM1 applications with the same password.
Go to folder C:\ide\tm1_ide\config and create the text file servers.json in notepad++
Enter below text, and adjust it to your ip number to your TM1 server, and the user and password to use.
TM1 IDE has been replaced by vscode-tm1, a Visual Studio Code extension for TM1. While many of the ideas from this project have been carried forward into vscode-tm1, this project has been deprecated and will be left here for reference.
Old Description
Still pending official name – for now TM1 IDE will be used. The goal of TM1 IDE is to implement a development environment with a desktop feel for both rules and processes. With the onset of the IBM provided Rest API, there has been a proliferation of web-based editors, but nothing that provides a true native experience for the more traditional developer. This project aims to cut through the feature overload that has become increasingly popular, and provide the average developer with a simple, clean interface that stays out of their way.
How to use
Ensure NodeJS/npm is installed.
Open a shell (Powershell in this example) and run the following after cloning to install project dependencies:
TM1 IDE — The Complete IDE for IBM Planning Analytics / TM1
Author: flameY3T1
TM1 IDE turns VS Code into a full development environment for IBM Planning Analytics / TM1. Write TI processes and rules with real autocomplete and a server-backed compile check, browse and edit cubes and dimensions visually, run MDX, trace process call graphs, test processes without touching your data, and mirror everything to Git — all from one tree, across as many servers as you like.
If you’ve been switching between Architect, PAW, and a text editor, TM1 IDE replaces all three with a single, modern, keyboard-driven workflow. No prior VS Code experience required — this guide gets you running.
Why TM1 IDE
Most TM1 editors stop at “edit a process, push it back.” TM1 IDE goes further:
Visual cube & dimension editing — pivot cubes, write back values, spread, and restructure hierarchies by drag-and-drop. Not just code.
Server compile-check on save — bad code never reaches the server. The save is blocked, not silently broken.
Configurable linter + formatter — per-server rule sets and severities: strict on Prod, relaxed on Sandbox.
Call-graph & references — see the blast radius of a process before you change it.
Git mirror — materialize processes and rules as files, with drift detection and diff.
Fully localized — complete English and German UI.
Getting Started
Step 1 — Install
Open your favorite IDE (VS Code, Kiro, …).
Open Extensions (Ctrl+Shift+X), search for “TM1 IDE”, click Install.
Fully restart the IDE — a window reload is not enough.
A new TM1 Explorer icon appears in the activity bar — your main entry point.
Root cause: PAW validates all logins against one specific TM1 server — the TM1 Login Server — configured in PAW Admin Console → Configuration → TM1 Login Server URI. Users created on any other server are invisible to PAW auth.
Fix shipped:
Added PAW_LOGIN_SERVER to .env and .env.example
All 10 user/group routes in server.js now always target PAW_LOGIN_SERVER regardless of selected workspace server
README updated with new “PAW Login Server” section
V12 note: TM1 Login Server is a V11-only concept. User management in the IDE must be adapter-aware — disabled or routed to IdP on V12/OIDC environments.
2. PAW Architecture — Key Facts
PAW is not a separate user store — in TM1 native auth mode, TM1 }Clients IS the user store
PAW has one designated TM1 Login Server for auth — all logins validated there (V11 only)
PAW discovers TM1 servers via the TM1 Admin Host (port 5895 HTTP / 5898 HTTPS) — a separate service acting as a server registry. TM1 servers register themselves on startup
PAW V12 replaces the TM1 Login Server concept with OIDC — identity comes from the IdP, not }Clients
The TM1 Login Server constraint is V11-only
Admin Host discovery API (direct, reliable):
GET http://{adminhost}:5895/api/v1/Servers
GET https://{adminhost}:5898/api/v1/Servers
Included in the IBM Postman collection but explicitly noted as “not exposed through the PAW proxy”. Do not depend on this without testing on your instance. tm1_paw_tree documents: “PAW has no endpoint to list TM1 server names”.
3. Arc vs Our IDE — Connection Model
Arc connects directly to TM1 via the Admin Host, bypassing PAW entirely. For IBM Cloud / AWS, Arc uses IBM IAM API keys → Bearer tokens — direct Admin Host is blocked by cloud firewalls.
Key discovery: the TM1 OData path suffix is identical across all deployment types:
Only the auth mechanism, base URL, and PAW API version prefix change. Our existing PAW-proxy architecture is the right shape — it just needs pluggable auth underneath.
by Roger·Comments Off on How edit text in excel cell
Product:
Planning Analytics 2.1.19 for excel
Microsoft Windows 2022 server
Issue:
In a PAFE (PAX) report where a cell have a formula with @DBRW the cell is not updateable, you have to write the full value again. Is there a way to edit the text in a cell without destroying the formula?
Solution:
Place the cursor in the cell to update.
In Excel press F2 followed by F9 and then edit text in cell, press enter when done.
If you publish the excel report to TM1WEB, then in TM1WEB you can edit the cell direct and the values are stored in the cube.
The wusa usage to quietly uninstall an update has been deprecated. The uninstall command with /quiet switch fails with event ID 8 in the Setup event log. Uninstalling updates quietly could be a security risk because malicious software could quietly uninstall an update in the background without user intervention.
Issue around Microsoft’s June 9th, 2026 cumulative Windows update that Microsoft is working to address. This patch has caused an error with a component that prevents the opening of word documents in CDM. Issue
When users attempt to open Word Objects or Generate Reports in CDM the following error is displayed: “The content of the file is corrupted.”
Root Cause
This issue is caused by an unanticipated change introduced in. Below is a list of the affected updates:
KB5094127 (Windows 10 version 21H2 and 22H2)
KB5093998 (Windows 11 version 23H2)
KB5094126 (Windows 11 version 24H2 and 25H2)
KB5095051 (Windows 11 version 26H1)
For instances where the CDM client may be published in Citrix (Office is on the Server):
KB5094042 (Windows Server 2012)
KB5094122 (Windows Server 2016)
KB5094123 (Windows Server 2019)
KB5094128 (Windows Server 2022)
KB5094125 (Windows Server 2025)
Solution
NOTE: Microsoft has acknowledged the issue was caused by the Microsoft June 9th update and they are also working on a resolution (as mentioned in the “Known issues with this release” section of the affected KBs above) and will be included in a future Windows update.
Additionally, the CDM team has identified the component in conflict with the update and are working hard in attempt to resolve the issue given the critical nature and its impact to our customers, coupled with the lack of a timeline on the update from Microsoft.
We believe the update will be delivered in CDM 26.2.0 (target release early July, 2026). Further updates, including progress and expected timelines, will be communicated as they become available.
Planning Analytics 2.1.19
Microsoft Windows 2022 server
Issue:
How dynamically set the data source to a tm1 view?
Solution:
In prolog build up the subset and view, and then add
#--- set the view to use
DataSourceType = 'VIEW' ;
DatasourceNameForServer = Cube ;
DatasourceNameForClient = Cube ;
DatasourceCubeview = ViewName ;
# Change to get semicolon in the text file
# DatasourceASCIIQuoteCharacter='';
# DatasourceASCIIDelimiter = ';';
# Change to get comma in the text file
DatasourceASCIIDelimiter = ',';
DatasourceASCIIDecimalSeparator = '.';
DatasourceASCIIQuoteCharacter = '"';
When you create or edit a TurboIntegrator (TI) process in Planning Analytics Workspace (PAW), TM1 Architect often fails to read the code properly due to a known compatibility issue. When opened in Architect, the process can appear blank on certain tabs.
In latest version of PAW, you should have most of the functions you need – and therefor the need to use TM1 architect should be limited.
The Root Cause
This occurs because of a few structural differences between the two editors:
• Variable Mapping: PAW does not always send data source variable names and types to Architect properly.
• Auto-generated Code Comments: Architect relies on auto-generated comments (like the lines defining data source parameters in the Prolog/Data tabs). When you open a PAW-built process, Architect attempts to add them, which can wipe out existing code or leave the screen blank.
Take a full backup of the installed folders, by copy them to an other drive. That is folder: D:\Program Files\ibm\tm1_64
and D:\Program Files\ibm\cognos\tm1web
Take screen shoot how it looks like to login to TM1WEB, PAW and IIS. In case you have customize any web pages, so you can see when you have it back correct.
Take a backup of the TM1 applications, like zip the data folder to a other drive. Run SaveDataAll before you zip the data folder for the TM1 instance.
by Roger·Comments Off on Error occurred while updating the server info json file java.lang.NullPointerException: Cannot invoke “java.lang.String.length()” because “s” is null
Product:
Planning Analytics Workspace 2.1.19
Microsoft Windows 2022 server
Issue:
PAA agent is not connecting to PAW.
The file serversinfo.json in folder D:\Program Files\IBM\tm1_64\paa_agent\paaAgentCache should contain the names of your Tm1 instances. If it is empty, the python script have maybe not been able to read the windows services information.
Error in messages file in folder D:\Program Files\IBM\tm1_64\paa_agent\wlp\usr\servers\kate-agent\logs
[5/5/26, 15:56:20:933 CEST] 00000046 com.ibm.pa.kate.agent.scheduler.ScheduledTask E Error occurred while updating the server info json file
java.lang.NullPointerException: Cannot invoke “java.lang.String.length()” because “s” is null
at org.python.core.PyString.charsFitWidth(PyString.java:122)
at org.python.core.Py.fileSystemEncode(Py.java:786)
at org.python.core.PySystemState.initArgv(PySystemState.java:1324)
[5/5/26, 15:57:40:994 CEST] 00000046 ice.notification.PaKateServerUnresponsiveNotificationService E Error occurred while getting latest servers info from json file
java.lang.NullPointerException: Cannot read field “modules” because the return value of “org.python.core.Py.getSystemState()” is null
at org.python.core.PyModule.module___init__(PyModule.java:64)
at org.python.core.PyModule.<init>(PyModule.java:47)
at org.python.util.PythonInterpreter.<init>(PythonInterpreter.java:104)
Solution:
Restore to the bootstrap.properties file that was installed with the upgrade.
Do not use a backed up file of bootstrap.properties – only add the SMTP parameters you need manually to the new bootstrap.properties.
SMTP_EMAIL_START_TLS_ENABLE=FALSE
SMTP_EMAIL_PASSWORD=
SMTP_EMAIL_PORT=25
SMTP_EMAIL_AUTH=FALSE
SMTP_EMAIL_USERNAME=
PAA_EMAIL_ADDRESS=yourname@domain.com
SMTP_EMAIL_HOST=smtp.yourcompany.domain.com
SEND_GRID_API_KEY=””
Start the PAA agent from the bat file: D:\Program Files\IBM\tm1_64\paa_agent\bin\PAAAgentStart.bat
If above does not work also check this:
Re-register/Re-register the Agent Service: If upgrading to PAW 2.0.41 or higher, the agent must be updated.
Stop the service.
Run <install_dir>\paa\bin\PAAAgentDelete.bat.
Run <install_dir>\paa_agent\bin\PAAAgentSetJavaHome.bat.
Run <install_dir>\paa_agent\bin\PAAAgentRegister.bat.
Fix Java Path Issue: If the agent fails to start, run PAAAgentSetJavaHome.bat in <install_dir>\paa_agent\bin to ensure the correct Java home is set.
Generic:
Ensure the PAA Agent is updated to match the version of PA Workspace in use. If not, then download the newer PAA Agent .zip file from PA Workspace administration UI.
Review \paa_agent\wlp\usr\servers\kate-agent\bootstrap.properties for PAA Agent configuration errors
In \paa_agent\wlp\usr\servers\kate-agent\bootstrap.properties verify SERVERS_DIR points to the parent folder of the TM1 data directories, not directly to one specific data directory.
Review \paa_agent\wlp\usr\servers\kate-agent\server.xml for WLP-related errors
Review \paa_agent\wlp\usr\servers\kate-agent\logs\ for errors
Review \pa_workspace_install\logs\monitor\ for errors *The monitor service is what the PA Workspace Administration page uses to communicate with the PAA Agent
Ensure that the IBM Planning Analytics Administration Agent service is running
Ensure that the IBM Planning Analytics Administration Agent service account is configured with english locale
Verify that the PAA Agent URL is accessible in a web browser where PAA Agent is installed (ignore the SSL certificate warning)
URL: https://localhost:9012
If available, PAA Agent just responds “NOT FOUND The application or context root for this request has not been found” *PAA Agent runs on Port 9012 and uses SSL by default
Verify that PAA Agent is accessible from inside the docker virtual network of PA Workspace. Open Powershell and run these commands:
docker exec -it monitor Powershell
cd curl*
cd bin
.\curl -v telnet://paa_agent_servername ipaddress:9012
Replace “paa_agent_servername” by the exact server name specified in \config\paw.ps1 for “TM1Location” parameter (since PA Workspace finds PAA Agent server from TM1 Admin Server location)
Verify that the PAA Agent URL is also accessible through the Planning Analytics Workspace host by using browser or curl command
URL: https://paa_agent_servername:9012
Verify that PAA Agent is listening on port 9012: from Windows start menu, run “resmon.exe”, select “Listening Ports”, and verify “javaw.exe” is listening on port 9012
In Planning Analytics Administration Tool page, verify the IP addresses returned for the Admin Host and TM1 Server
URL: http://workspace_servername:8888
Does your PAA Agent bootstrap.properties file contain a AGENT_API_KEY setting?
at java.base/sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at java.base/sun.nio.fs.WindowsFileSystemProvider.createDirectory(Unknown Source)
Then you have more than one DATA folder, and the model_upload folder is created in wrong data folder. PAW PA Agent does not support more than one DATA folder listed in TM1S.CFG file.
by Roger·Comments Off on Blank page when run standard report
Product:
Cognos Analytics version 12.1.2.15
Cognos Controller version 11.1.1003
Microsoft Windows 2022 server
Issue:
After upgrade to later version of Cognos Analytics, that is used for CAM login and Controller standard reports, the reports inside Cognos Controller does not work.
Solution:
The newer version of CA 12.0.4 and later have a different setup of MIME parameters. This is setup in IIS by the new CA_IIS_Config.bat script.
You can add it manually to IIS.
Go to IIS Manager and select the web site “ibmcognos”
Click on the MIME types icon
Add this
.mjs : application/javascript
Click OK
And restart the IIS server.
Restart Cognos Controller and run a standard report again.
If the PDF report works in Chrome, but not in a Edge browser, then you may need to add this:
Revert the report viewer to a more compatible display style, by making a change to the system’s Advanced Settings:
.
