CogKnowHow

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

Product:

Planning Analytics 2.0.9.13

Microsoft Windows 2019 server

Issue:

How easy create a parameter cube, where we can store common values like file paths or servername, that change when we move the TM1 application between servers.

Suggested solution:

Create a TI process with this PROLOG – update the values to your need:

#--------------------------------------------------------------------
# process to create a simple parameter cube
#--------------------------------------------------------------------

CubeName1 = 'SYS.ParameterCube';
DimName1 = 'sys.value' ;
DimName2 = 'sys.function' ;

# create dimension
IF ( DimensionExists ( DimName1 ) = 0 ) ;
DimensionCreate ( DimName1 ) ;
ENDIF ;

IF ( DimensionExists ( DimName2 ) = 0 ) ;
DimensionCreate ( DimName2 ) ;
ENDIF ;

#add elements to dimension
Elname1 = 'ExportFileArea';
Elname2 ='String';
Elname3 ='Number';
Elname4 = 'Explanation' ;
ElType1 = 's'; 
ElType2 = 'n';

DimensionElementInsert (DimName1, '' ,ElName2, ElType1 ) ;
DimensionElementInsert (DimName1, '' ,ElName3, ElType2 ) ;
DimensionElementInsert (DimName1, '' ,ElName4, ElType1 ) ;
DimensionElementInsert (DimName2, '' ,ElName1, ElType1 ) ;

# then only add extra rows for other functions
# Elname5 = 'Servername';
# DimensionElementInsert (DimName2, '' ,ElName5, ElType1 ) ;

# create a cube
IF( CubeExists( CubeName1 ) = 0 ) ;
CubeCreate ( CubeName1 , DimName2 , DimName1 ) ;
ENDIF ;


# add default values to the matrix
sFirstPath = '\\servername\filesharename\' ;
sExplain = 'The path to be used in beginning of filepath used in file exchange' ;

CellPutS ( sFirstPath , CubeName1 , Elname1 , Elname2 ) ;
CellPutS ( sExplain , CubeName1 , Elname1 , Elname4 ) ;

Run the TI process to create the dimensions and cube.

Then on the TI process that should use the parameters, include a code like this:

# use the values to write a file

# define variables
CubeName1 = 'SYS.ParameterCube';
Elname1 = 'ExportFileArea';
Elname2 ='String';
vFile = 'magicfile.txt';

# get value from parameter cube
vReplacePath = cellgets ( CubeName1 , Elname1, Elname2 ) ;

# create the new path and file name
vPath = vReplacePath | 'data\' ;
vFilePath = vPath | vFile ;

# write to the file
ASCIIOUTPUT ( vFilePath , 'This is the text written to the file' );

This code can be improved – that is up to you.

More Information:

https://exploringtm1.com/asciioutput-tm1-function-use-syntax/ 

https://www.wimgielis.com/tm1_clearingbigchunksofdata_EN.htm 

https://exploringtm1.com/dimensionelementinsert-tm1-function-use-syntax-and-examples/ 

https://exploringtm1.com/cellputs-tm1-function-use-syntax/