Product:

Planning analytics 2.0.9
Microsoft Windows server

Problem:

What ports are used by PAL?

Solution:

 

Check this article from  https://www.ibm.com/support/pages/what-are-port-numbers-used-ibm-planning-analytics-products 

Ports used by Planning Analytics
5495   The unsecured TCP/IP port number on which the Admin Server listens for client requests (if allowed in Cognos Configuration).

 

5498   The secured TCP/IP port number on which all TM1 components communicate with the Cognos TM1 Admin Server using Transport Layer Security (TLS).

 

5895     Admin Server to REST API unsecured communication port number (tm1AdminHTTPPortNumber). Specifies the HTTP port number that is used by TM1 Admin Server to communicate with the TM1 REST API for unsecured communication (if allowed). The default value is 5895. This default value cannot be changed using IBM Cognos Configuration. For more information, see “Appendix 1: TM1 Admin Host” in the TM1 REST API documentation.

 

5898   Admin Server to REST API secured communication port number (tm1AdminHTTPSPortNumber). Specifies the HTTPS port number that is used by TM1 Admin Server to communicate with the TM1 REST API for secured (SSL) communication. The default value is 5898. This value cannot be changed using IBM Cognos Configuration.
For more information, see “Appendix 1: TM1 Admin Host” in the TM1 REST API documentation.

 

<portNumber> The port on which the TM1 server runs. This parameter is used to distinguish multiple TM1 servers running on the same computer. Valid port values fall between 5000 and 65535. The default value is 12345 (already used by Planning Sample). This parameter is to be set in the Tm1s.cfg server configuration file.
12345  Default portNumber for Planning Sample
12346  Default portNumber for SData
45557  Default portNumber for GO_New_Stores
12347  Default portNumber for PData
5333   Default portNumber for Proven_Techniques
44321  Default portNumber for GO_scorecards
50909  Default portNumber for 24Retail

 

<HTTPPortNumber> Port number on which the TM1 Server listens for incoming HTTP(S) requests. The IBM Planning Analytics TM1 Server services the REST API using this HTTP(S) channel. The server accepts either standard HTTP or SSL secured HTTPS connections depending on the UseSSL parameter: If UseSSL is set to T, switching the use of SSL on, then the server will accept only HTTPS connections, if UseSSL is set to F then the server will accept unsecured HTTP connections. If HTTPPortNumber is not defined in your tm1s.cfg file, then port number “5001” will be assigned automatically. This parameter is to be set in the Tm1s.cfg server configuration file.
12354  Default HTTPportNumber for Planning Sample
8010   Default HTTPportNumber for SData
5010   Default HTTPportNumber for GO_New_Stores
8011   Default HTTPportNumber for PData
5011   Default HTTPportNumber for Proven_Techniques
44312  Default HTTPportNumber for GO_scorecards
52670  Default HTTPportNumber for 24Retail

 

<ClientMessagePortNumber>  TM1 Client Message port number. This port number establishes a secondary port for client progress messages to use when a lengthy operation is waiting to be canceled. This parameter is to be set in the Tm1s.cfg server configuration file. The default value is blank. By default, this port number is automatically and dynamically assigned when the TM1 server starts. You do not have to set ClientMessagePortNumber to a specific number unless firewalls or other network issues require the listener port to be a well-known number.
CAUTION: If you choose to set a specific value for the ClientMessagePortNumber parameter, instead of having it dynamically assigned, be sure to assign unique port numbers for all the TM1 server and client message ports you are using. If you have two servers running on the same machine using the same port number, the message activity may cause a system conflict or hang.
17469  Default ClientMessagePortNumber for 24Retail

 

<LDAPPort>    Port that IBM TM1 Server uses to bind to an LDAP server. It is used if PasswordSource=LDAP in tm1s.cfg. The default LDAPPort is 389 (unsecured). Usually, in production, secured port 636 is used instead (LDAPS).

 

9510    Default port for both TM1 Application Server (depending on “IBM Cognos TM1” service) and IBM Planning Analytics Spreadsheet Services (the new TM1 Web that depends on “IBM Planning Analytics Spreadsheet Services” service). If both services are still needed on the same machine, then this default port has to be changed for one of them, and TM1 Application Web (pmpsvc) may have to be reconfigured to connect to TM1 Web. Follow this document to achieve this: “How to Configure TM1 Application Web to connect to TM1 Web since 2.0.9.2 ? (IBM Planning Analytics Spreadsheet Services)

 

53      Docker daemon port.

 

80         Planning Analytics Workspace’s PAGatewayHTTPPort (to be defined in /config/paw.ps1). This is an HTTP port that is mapped to the host by pa-gateway. The default value is 80.

 

443     Planning Analytics Workspace’s PAGatewayHTTPSPort (to be defined in /config/paw.ps1). This is an HTTPS port that is mapped to the host by pa-gateway. The default value is 443.

 

9012     To use IBM Planning Analytics Administration on Planning Analytics Workspace Local, you install and configure the Planning Analytics Administration agent wherever you install IBM TM1 Server. The default port of the Planning Analytics Administration agent is 9012. This port cannot be easily changed because it is hardcoded in the docker image of the container that is accessing the Administration Agent.

 

8888     Default admintool port. By default, the Planning Analytics Workspace administration tool is accessible on http://127.0.0.1:8888.
In IBM Planning Analytics Workspace Local version 2.0.44 or later, if port 8888 is not free, you can configure Planning Analytics Workspace Local to access the Planning Analytics Workspace administration tool remotely on Windows Server. For more information, see “Access the Planning Analytics Workspace administration tool remotely on Windows Server“.
If you can’t run a browser on the localhost interface, you can configure Planning Analytics Workspace Local to access the Planning Analytics Workspace administration tool on another IP address. For more information, see “Access the Planning Analytics Workspace administration tool remotely on Linux

 

 

More Information:

https://www.ibm.com/support/pages/blank-white-page-rendered-while-opening-websheets-within-planning-analytics-workspace 

https://www.ibm.com/support/pages/node/6985967

Product:

Planning Analytics 2.0.9.16

Microsoft Windows 2019 server

Issue:

How change TM1 Application web (pmpsvc) to use CAM SSO security when it have been setup to use Native TM1 security before?

Solution:

If you only have one tm1 application connected to tm1 app web (common in new installations – like planning sample in our example).

Stop the “IBM Cognos TM1” service (pmpsvc web server).

Open the file fpmsvc_config.xml from D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration folder.

Remove the planning sample line from between servers section.

So it looks like this;

<servers>
</servers>
</admin_host>
</tm1>

Save the file.

Change you planning sample tm1s.cfg file to have correct values like below:

IntegratedSecurityMode=5

ServerCAMURI=http://cognosserver.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://cognosserver.domain.com:80/ibmcognos/bi/v1/disp

Save tm1s.cfg file and restart the planning sample service.

Test to login to planning sample in Tm1 Architect, it should work with CAM SSO if all is correct.

Then browse to your tm1 app web on:

http://planninganalyticsserver.domain.com:9510/pmpsvc

If all works well – you should get to the configuration page – where you can select Tm1 instance. Select a TM1 instance that will be up and use CAM security. All Tm1 applications that are used inside Tm1 Application web (contributor) must all have the same security settings, most common is IntegratedSecurityMode=5.

Save the settings and you should get into the IBM Cognos Tm1 Applications portal. If you need to edit the configuration later, click on the tools icon.

In Cognos TM1 Applications Configuration web page, click on Edit link, below the selected server names.

Then fill out the fields – for any change needed.

Admin host = should be the server-name of windows server where Tm1 Admin service is running (normally the tm1 server itself).

Server Name = should be the selected TM1 instance, that user will first be authenticated against. Should be using CAM SSO, as describe above.

Cognos BI Gateway URI = should be to the gateway like http://cognosserver.domain.com:80/ibmcognos/bi/v1/disp

Cognos BI Dispatchers URI = should be point to the CA11 server on port 9300 like http://cognosserver.domain.com:9300/p2pd/servlet/dispatch

Click OK to save, and there should not be any errors. If errors check in IE on server if you can browse to above URL for Cognos BI.

 

If you turn off the planning sample application and change it to IntegratedSecurityMode=5, without change in fpmsvc_config.xml file, then you get a Tm1 login dialog in TM1 App Web when you connect and you can not login. This becouse “pmpsvc” is setup for Native Security. You need to change planning sample back to IntegratedSecurityMode=1 to be able to login to Tm1 App Web again.

To clear a TM1 Application from TM1 APP WEB connections, so you can work with the TM1 instance in TM1WEB, you need to run TI process:

}tp_admin_delete_all

 

More Information:

https://www.ibm.com/docs/sr/planning-analytics/2.0.0?topic=web-configuring-tm1-application 

https://allthingscognos.wordpress.com/2014/08/26/configuring-performance-modeller-and-tm1-web-with-cam-security-for-tm1-10-2-n/ 

You can maybe edit pmpsvc_path\WEB_INF\configuration\log4j.properties file in the same folder to change log level to INFO or DEBUG to get a lot more info in WEB_INF\logs\pmpsvc.log… or check folder D:\Program Files\ibm\cognos\tm1_64\wlp\usr\servers\tm1\logs for messages.log files.

https://www.ibm.com/support/pages/how-manually-reset-deployed-tm1-applications 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=mctaip-resetting-application-in-portal 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=security-standard-cognos-tm1-authentication

Product:

Planning Analytics 2.0.9.17  TM1-AW64-ML-RTM-11.0.917.9-0
Microsoft Windows 2019 server

Issue:

How upgrade TM1 on a server?

Solution:

Follow IBM instructions and do a in-place upgrade.

https://www.ibm.com/docs/bg/planning-analytics/2.0.0?topic=configuration-upgrading-planning-analytics-local 

Please remember to take backup of the important files.

The samples database is overwritten, take a backup of this folder first:

D:\Program Files\ibm\cognos\tm1_64\samples\tm1

The preserve file list the files that are not replaced, take a backup of that tm1preserved.txt file in folder:

D:\Program Files\ibm\cognos\tm1web\configuration

Backup the tm1web_config.xml for TM1WEB from:

D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\configuration

Backup server.xml and jvm.options and bootstrap.properties files from folder:

D:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web

Server.xml contain the port that tm1web will use for access by users.

Backup the configuration in cognos configuration:

  1. Open Cognos Configuration.
  2. Click File > Export As.
  3. Select a location and enter a file name for the XML file.
  4. Click Save.

Backup of your PAA Agent bootstrap.properties file in folder:

D:\Program Files\ibm\cognos\tm1_64\paa_agent\wlp\usr\servers\kate-agent

Export the TM1 applications as a backup – the data is saved in the TM1 data folder.

  1. Open the TM1 Cognos Applications portal.
  2. Click the Export Application icon under the Actions column.
  3. From the File Download dialog box, click Save.
  4. Navigate to the directory to where you want to save the export file.
  5. Click Save.

Save the Tm1p.ini client configuration file for Cognos TM1 Architect and Cognos TM1 Perspectives from:

  • C:\Users\%username%\AppData\Roaming\Applix\TM1
  • C:\ProgramData\Applix\TM1

Maybe uninstall Planning Analytics Performance modeler from the windows server before you install the upgrade of TM1, to ensure you have the latest version installed.

 

Later version of Planning Analytics recommend change in TM1S.CFG file:

If you plan to use Cognos TM1 Applications without Microsoft Excel installed on the web server where you are running Cognos TM1 Web, you will need to explicitly set the ExcelWebPublishEnabled parameter to True (T) in the tm1s.cfg configuration file for your TM1 servers. Earlier versions of Cognos TM1 Contributor did not require this parameter to be set.

If the action button in tm1 websheet are wrong after the upgrade:

  1. Open the Excel sheet that contains the Action Button.
  2. Right-click the button, then click Properties.
  3. Clear and re-select the Resize Button to Caption option.
  4. Click OK.
  5. Publish the websheet again.

 

More Information:

https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=local-prerequisites-upgrading

https://exploringtm1.com/how-to-upgrade-planning-analytics-tm1/

https://www.ibm.com/support/pages/how-configure-tm1-application-web-connect-tm1-web-2092-ibm-planning-analytics-spreadsheet-services

https://www.pschwan.de/tm1-planning-analytics/ibm-tm1-planning-analytics-upgrade-per-skript

Product:

Planning Analytics Workspace 73

Issue:

When starting EXCEL and login to TM1 with PAFE you get a error after you have logged in.

The remote server returned an error: (404) Not Found.

Cognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (404) Not Found. —> System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Cognos.Office.Tm1.Connections.Tm1Request.GetResponse()
— End of inner exception stack trace —
at Cognos.Office.Tm1.Connections.Tm1Connection.HandleWebException(Tm1WebException x, Uri path)
at Cognos.Office.Tm1.Connections.Tm1Connection.GetResponse(Tm1Request request)
at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(Tm1Request webRequest, AcceptReturnEnum returns)
at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(String method, String path, String postData, AcceptReturnEnum returns, Int32 timeout)
at Cognos.Office.Tm1.Connections.Tm1Connection.Get(String path, AcceptReturnEnum file, Int32 timeout)
at Cognos.Office.Tm1.Rest.Tm1RestCapabilities..ctor(Tm1Connection connection, String server, Int32 timeout)
at Cognos.Office.Tm1.Rest.Tm1RestConnection.RefreshCapabilities(String server, String path)
at Cognos.Office.Tm1.Tm1DataSource.On_LogOn(String server)
at Cognos.Office.Tm1.Tm1DataSource.Logon(LogonType logonType, DataSourcePropertiesCollection properties)
at Cognos.Office.Framework.Communications.DataSourceManager.LogOn(String dsType, String connectionString, String serverName, IDataSource& source

In the background can Internet Explorer be open and show:

The webpage cannot be found
HTTP 404
Most likely causes:
•There might be a typing error in the address.
•If you clicked on a link, it may be out of date.

 

Suggested solution:

Check that you have a version of PAFE that is close to PAW version. https://www.ibm.com/support/pages/ibm-planning-analytics-microsoft-excel-conformance-requirements 

Inside excel on the IBM Planning Analytics ribbon select help – about. It should list version in lower right corner – like 2.0.73

If the help drop down menu show more than “using IBM Planning Analytics for Microsoft Excel” then you can have a old version.

Close excel.

Download a later version of PAFE from IBM.  https://www.ibm.com/support/pages/download-ibm-planning-analytics-local-v20-planning-analytics-microsoft-excel-release-83-fix-central

Check your version of excel – if it is 64 bit – click on the 64 bit xll file to start pafe ( IBM_PAfE_x64_2.0.73.3.xll ).

Select the IBM Planning Analytic ribbon and try to connect again.

Under options – IBM connections – you should point to the PAW servers URL.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=configuration-installing-configuring-planning-analytics-microsoft-excel

More Information:

https://exploringtm1.com/planning-analytics-for-excel-connection-to-tm1/

To add the xll to excel, do this:

  1. Download the Planning Analytics for Microsoft Excel .xll file from IBM Support Fix Central.
  2.  Rename the file to PAFEexcel.xll and move the .xll file to your desired directory. ( like c:\install ) (when you upgrade PAFE file in future you only need to replace the file on the computer – as the name is the same, the excel connection should stay working).
  3. Launch Microsoft Excel.

    When you install the Planning Analytics for Microsoft Excel .xll as an add-in to Excel, do not double-click the .xll file to open Planning Analytics for Microsoft Excel. This causes Excel to crash.

  4. Click the Developer tab.
  5. Click Excel Addins in the ribbon.
  6. Click Browse….
  7. Select the Planning Analytics for Microsoft Excel .xll file.
  8. Click OK.
  9. Go to file – options – trust center
  10. Click on Trust Locations
  11. Click on Add new location button
  12. Add the path to where you have saved your xll file.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=icpame-downloading-upgrading-planning-analytics-microsoft-excel-single-xll-add-in-versions-2065-later

Product:

Planning Analytics 2.0.9.3

Microsoft Windows 2019 server

Issue:

A few users can not see views in TM1WEB. They get a blank screen. If they become ADMIN, then the view works.

The issue is only for a few cubes. Other cubes work well.

Inside TM1WEB log you find this error:

[Default Executor-thread-9556] ERROR ([]) com.ibm.cognos.tm1.web.services.CubeViewService – [] Exception Error: null Stack Trace: java.lang.reflect.InvocationTargetException

Caused by: java.lang.ArrayIndexOutOfBoundsException
at com.applix.tm1.TM1Val.getArrayVal(TM1Val.java:310)

Log files are found at D:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\logs\messages.log and

D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\logs\tm1web.log

Solution:

The user that have issues, does not have READ rights to the picklist in the cube where the view is. They have access rights to the cube and dimensions, but not to the picklist cube that is used by the rule in the cube.

Turn on “display control objects” in TM1 Architect.

Go to Cube – Security Assignments.

Check that, the group the users are part of, have READ for the hidden picklist for the cubes they have problems with.

They start with }PickList_

Increase of memory for JAVA did not solve the issue.

More Information:

https://tech.forums.softwareag.com/t/java-garbage-collection-tuning-strategy-an-example/236936

https://www.digitalocean.com/community/tutorials/java-jvm-memory-model-memory-management-in-java

https://blog.gceasy.io/2022/03/04/garbage-collection-tuning-success-story-reducing-young-gen-size/

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=lists-creating-pick-control-cubes

https://exploringtm1.com/tm1-picklists/ 

Product:

Planning Analytics 2.0.9.13

Microsoft Windows 2019 server

Issue:

How keep settings cube values in test, when you copy the production tm1 data folder over?

Solution:

Use two data folders – one for the cube you do not want to copy and the other folder for the rest.

Setup your TM1 instance, and create the data folder.

Create your sys.settings cube and other you need in your application.

Inside TM1 Architect click on Save Data.

Stop the TM1 instance.

Create a new data folder called: data_syssettings

Move the sys.settings cube to the new folder.

Update the TM1S.CFG file for the new data folder.

# Example:
# DataBaseDirectory=C:\Program Files\Cognos\TM1\Custom\TM1Data\PlanSamp\
DataBaseDirectory=".\Data;.\Data_SysSettings"
LoggingDirectory=D:\TM1 data\FAP\Logs

Save the TM1S.CFG file and start the TM1 instance.

Changes to the cube in the other folder will only be written to that folder.

 

A other way is to store the environment values in a text file on the server, and then have a TI process that you run that will update the sys.settings with the correct values for this server. Run that TI process every time after you have copied over the data folder from PROD to TEST server.

 

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=architecture-data-directory-overview 

You can specify that you want IBM TM1 Server to use multiple data directories by separating the directory names with semicolons. When you specify multiple data directories, TM1 does the following.
  • Accesses cubes and dimensions from each of the specified directories. If there is a duplicate object, TM1 accesses the object from the first directory specified.
  • Writes changes to the directory where the object is located. When you create a new object, TM1 writes to the first directory you had specified.

https://www.redhat.com/sysadmin/linux-path-absolute-relative 

The ASCIIOutput and TextOutput TurboIntegrator functions do not work with the output path of \\data\s on the Planning Analytics system. Instead, use ./ to indicate a relative path to the TM1® data directory and shared folder on your Planning Analytics system in the cloud.

https://www.ibm.com/docs/sv/planning-analytics/2.0.0?topic=cloud-relative-paths-asciioutput-textoutput-functions 

 

Product:

Planning Analytics 2.0.9.13

Microsoft Windows 2019 server

Problem:

Can i change the background picture in tm1web?

Solution:

There is no guide for this – but the images used are found in folder like D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\scripts\tm1web\themes\carbon\planning\images

SVG images are dynamic in size and should be edit with a software that can save in SVG format.

D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\scripts\tm1web\themes\carbon\standalone\images\login\PA_Header.svg is the file that create the background in the TM1WEB.

You can edit the file at https://svgedit.netlify.app/editor/index.html

The change to the pa_header.svg file is direct visible in tm1web.

You can download inkscape to edit the SVG file, and add some text to it. https://inkscape.org/release/inkscape-1.3.2/windows/64-bit/msi/

When you add some text, it will look similar to this, last in the SVG file if you edit it in Notepad++

 <text
xml:space="preserve"
id="text691"
style="font-size:85.3333px;white-space:pre;shape-inside:url(#rect691);fill:#000000;stroke-width:1.00157;stroke-dasharray:none"><tspan
x="594.41211"
y="517.41287"
id="tspan2"><tspan
style="font-family:AnticFont;-inkscape-font-specification:AnticFont;fill:#ff0000"
id="tspan1">Use</tspan></tspan><tspan
x="594.41211"
y="630.80282"
id="tspan4"><tspan
style="font-family:AnticFont;-inkscape-font-specification:AnticFont;fill:#ff0000"
id="tspan3">chrome </tspan></tspan><tspan
x="594.41211"
y="744.19278"
id="tspan6"><tspan
style="font-family:AnticFont;-inkscape-font-specification:AnticFont;fill:#ff0000"
id="tspan5">browser</tspan></tspan></text>

 

You maybe can find out how to edit the SVG file direct in notepad.

Chrome may not show the text, but Internet Explorer will do it – depends on the font you select to use. Also space in the font name can give you trouble in chrome.  https://www.she-philosopher.com/home/technical/BrowserProblems.html 

Take a backup of your SVG file before you start edit it.

 

More Information:

https://apliqo.screenstepslive.com/m/Release_Notes/l/844719-new-features

https://blog.hubspot.com/website/web-safe-html-css-fonts

Using a custom web fonts in *.svg

https://css-tricks.com/system-fonts-svg/

https://developer.mozilla.org/en-US/docs/Web/SVG/Tutorial/SVG_fonts

https://vecta.io/blog/using-fonts-in-svg

Product:

Planning Analytics 2.0.9.13 TM1_version=TM1-AW64-ML-RTM-11.0.913.10-0

Cognos Analytics 11.1.7 FP6 kit_version=11.1.7-2210041400

Microsoft Windows 2019 server

Issue:

A new setup of PAL and CA11 on the same windows server, where you have configured SSO and CAM security.

Login to IBMCOGNOS works fine, also login to TM1 Architect is working.

When a user try to login to TM1WEB, they get a error after selecting the TM1 instance to use.

The webpage cannot be found
HTTP 404
Most likely causes:
•There might be a typing error in the address.
•If you clicked on a link, it may be out of date.

The url say something like:

http://tm1sername.domain.com/ibmcognos/bi/tm1/web/tm1web.html?cam_passport=MTsxMD5hMGx3ZjYxLTk1M2Qt2NDUyNjVlOjIzxMDY7MDszOzA7&server=
Domain%20Admin&ps=http%3a%2f%2ftm1sername.domain.com%3a9511&pg=applications.jsp&host=bG9jYb3N0

Solution:

The tm1web.html file is missing from folder D:\Program Files\ibm\cognos\analytics\webcontent\bi\tm1\web.

Copy the folder D:\Program Files\ibm\cognos\analytics\webcontent\tm1 to D:\Program Files\ibm\cognos\analytics\webcontent\bi\tm1.

 

If you get error PRS-PRH-0221 The file “portal/variables_TM1.xml” could not be opened.  Rename the file variables_TM1.xml.sample to variables_TM1.xml in folder D:\Program Files\ibm\cognos\analytics\templates\ps\portal.

The url in IBMCOGNOS is something like: http://servername.domain.com/ibmcognos/bi/v1/disp?b_action=xts.run&m=portal/bridge.xts&c_env=portal/variables_TM1.xml&c_cmd=../tm1/web/tm1web.html&ps=http://….

D:\Program Files\ibm\cognos\analytics\templates\ps\portal\variables_TM1.xml file does not need to be edit any longer. The default variables_TM1.xml needs to stay as is. It is still required (if configured in the tm1s.cfg), but the application will be using the specified tm1web.html file, instead, to redirect the user from the BI (after being authenticated by CAM) to the tm1web server.  Looks like the CA11 in some configurations require this file.

More Information:

https://www.ibm.com/support/pages/initializing-tm1-applications-cam-http-404

https://www.ibm.com/support/pages/http-errpor-404-hitting-tm1web-url 

https://www.ibm.com/support/pages/how-setup-tm1-web-and-tm1-applications-cam-authentication 

https://www.ibm.com/support/pages/prs-prh-0221-portalvariablestm1xml-could-not-be-opened

Product:

Planning Analytics 2.0.9.15

Microsoft Windows 2022 server

Issue:

In a setup where TM1 authenticates with Cognos Analytics 11.2.4 (CAM login) and have a working SSO login. After adding SSL (HTTPS) to the CA11 gateway, you get a warning message when you login to TM1WEB.

The information you’re about to submit is not secure – this is from the web browser that warns that you switch between HTTPS and HTTP websites.

You click Send Anyway and you are logged into tm1web.

Solution:

Ensure that you also use HTTPS on your TM1WEB site.

Set it up from this instructions:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=itw-configure-ssl-planning-analytics-tm1-webspreadsheet-services-existing-keystore

Ensure that all DNS names and alias for you Cognos/Tm1 servers are part of your certificate.

 

More Information:

https://www.digicert.com/blog/not-secure-warning-what-to-do

Product:

Planning Analytics 2.0.9.3

Microsoft Windows 2019 server

Issue:

How move data folder from server A to server B and keep the tm1websheets that are created in applications?

 

Solution:

The TM1WEBsheets you publish from TM1 Perspective, are stored under the data folder, in a folder named }Externals.

Take a backup of that folder ( D:\TM1 Data\tm1instancename\Data\}Externals )

Copy the data folder from server A to server B.

Put back the }Externals folder, and you will have your previous websheets the same as before.

More Information:

  • TM1 copies and saves uploaded files to the TM1 server in the following directory: <server_data_dir>\}Externals directory.
  • When a file is uploaded to the TM1 server, the file name is appended with a time/date stamp.For example, if you upload the file US Budget.xls to the TM1 server, the file is saved as US Budget.xls_20040702193054.xls.
  • When you delete an uploaded file from a TM1 application, TM1 deletes the copy of the uploaded file from the }Externals directory. The original file, outside of TM1, that the uploaded file was copied from, is not deleted.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=application-behavior-files-uploaded-tm1-server 

https://www.ibm.com/support/pages/http-403-forbidden-error-accessing-tm1-web-url-cognos-connection-or-external-site