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 

• 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 

Product:

Planning Analytics Workspace 75

Microsoft Windows 2019 server

Issue:

When in PAW administration, and you click on the databases and select one to see the treads – you get a error message.

“There has been an issue processing this request. Please try again later.”

Possible solution:

Change the httpportnumber in use in the tm1s.cfg file to a port that is open in the network firewall between the tm1 server and the paw server.

PortNumber=12450
HTTPPortNumber=12550

If the Tm1s.cfg file does not contain the PortNumber parameter, the TM1 server uses port 5000.

When you install a new TM1 server, the default HTTP port number is 12354. Valid port values are between 5000 and 49151.

If the Tm1s.cfg file does not contain the HTTPPortNumber parameter, then you can not use the OData v4 Compliant REST API.

Or open more ports in the firewall, between the servers.

More information:

https://www.ibm.com/support/pages/planning-analytics-administration-paa-unable-display-status-tm1-databases-agent-status-reflected-unreachable-within-paa-console 

https://community.ibm.com/community/user/businessanalytics/discussion/warning-paw-creatededited-ti-are-not-backwards-compatible-with-architect 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=cmpal-parameters-in-tm1scfg-fileplanning-analytics-engine-configuration-parameters

Product:

Planning Analytics 2.0.9.13

Microsoft Windows 2019 server

Issue:

How set that a user group only see some tm1 web sheets and not all in tm1 web for a TM1 instance?

Solution:

Inside TM1 Architect, you create the Applications, and add web sheets or files or views to the application. Create a extra folder (application) for normal users and a folder for admin users. Then drag the views to the different folders, and publish the web sheet to the different folders. This give that you have two folders under the main application folder.

Right click on your first application – and select new – application, that gives you a new folder.

Then right click on the top folder and select security – security assignments.

Set NONE for everyone except for the administrator group, on the admins folder. This will give that only people part of the admin group will have access to the folder and any content inside it, like web sheets or links.

In the left you see the objects, like the folders, and then in columns you have the groups you have defined. If you use CAM security, you can add the CA groups to columns. Mark on cell for a user group and the folder you want to change security for, set NONE, if no access should exist. Click on OK.

By creating applications (folders) and set security on then, you can add views and websheet to the folder, and they will have the same access as the folder.

Remember to make the folder and tm1websheets public, after you have made them part of the application.

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=developers-organizing-objects-in-tm1-applications

Creating a TM1 Contributor Model

http://web.archive.org/web/20180425055420/http://tm1up.com/10-tm1-applications.html#more-1345