IBM Support

TM1 URL API shows two security prompts when using CAM security

Troubleshooting


Problem

TM1 is secured with CAM security. When running a TM1Web report using urlapi.jsp there is the TM1Web classic security page that is shown for less than one second, followed by the Cognos BI security prompt (which appears blank for one second and then disappears if using single signon). Moreover, going from one TM1Web report to another using URL API is displaying these screens again like if the connection was not persistent. This is annoying for users.

Resolving The Problem

Solution 1: use TM1WebWebSheeterCAM.jsp instead of urlapi.jsp, this will not display these screens.

For example, instead of : http://servername:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&Work…

Use this : http://servername:9510/tm1web/TM1WebWebSheeterCAM.jsp?WebSheet=Applicat…

The only problem is that this jsp does not accept some urlapi parameters like Title_S#-R#-C# that allows to change the default selected elements in SUBNM formulas.



Solution 2: if receiving these screens is not a problem the first time, but users just don't want to see them again when opening other reports in the same session : just be sure to include AdminHost and TM1Server parameters in all the URLs even if they are not supposed to be mandatory if they are used in the first URL API.
Not using these parameters in all the subsequent URLs is what causes these security screens to reappear. One possible underlying cause may be that AdminHostName parameter in tm1web_config.xml (in \ibm\cognos\tm1_64\webapps\tm1web\WEB-INF\configuration) is not correctly set.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Web","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21693765