Hi Folks
I've installed PAW SC57 and also installed the PA spreadsheet services component on Centos7.
PAW works fine and I can access my TM1 server instance but I cannot view any of the TM1 websheet content.
Similar to this community post (excel will not render in PAW) :
https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=0b343def-7e58-41d3-bbd5-2a3a8b7f88d4&CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b&tab=digestviewer#bm0b343def-7e58-41d3-bbd5-2a3a8b7f88d4

I can access the TM1 websheets fine via the URL : http://servername:9511/tm1web/
I've followed the following documentation here :
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1web_pmpsvc_config.html
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1web_pmpsvc_config_linux.html

Ports have all been opened in firewall-cmd.
Any ideas on how to get this working ?.
Kind Regards

------------------------------
Nick Waters
------------------------------

#PlanningAnalyticswithWatson

I don't think this has been explained very well in the documentation (or at least I haven't found the correct part yet.)

In the workspace configuration window where you used to list your application server e.g. http://myapplicationserver:9510/pmpsvc
You now need to point it to your tm1 web server and port - in your case: http://servername:9511/tm1web/

That's how you tell workspace which tm1 web service to use (or spreadsheet service as well call it now) - hopefully in a future version the configuration screen will explain that bit better.

------------------------------
Declan Rodger
------------------------------

Hi @Declan Rodger
Not sure which configuration window you mean ?...do you mean the PAW admintool.sh ?.
If so, I have pointed my TM1 Application Server Gateway URI to this : http://servername:9511/tm1web​  - but it makes no difference.
Regards

------------------------------
Nick Waters
------------------------------

Original Message:
Sent: Wed November 04, 2020 10:46 AM
From: Declan Rodger
Subject: Cannot access TM1 websheets in PAW

I don't think this has been explained very well in the documentation (or at least I haven't found the correct part yet.)

In the workspace configuration window where you used to list your application server e.g. http://myapplicationserver:9510/pmpsvc
You now need to point it to your tm1 web server and port - in your case: http://servername:9511/tm1web/

That's how you tell workspace which tm1 web service to use (or spreadsheet service as well call it now) - hopefully in a future version the configuration screen will explain that bit better.

------------------------------
Declan Rodger
------------------------------

Yes the administration tool.
It should be the application server gateway as you have it but without the /tm1web on the end - it should just be server and port number.

------------------------------
Declan Rodger
------------------------------

Original Message:
Sent: Wed November 04, 2020 11:01 AM
From: Nick Waters
Subject: Cannot access TM1 websheets in PAW

Hi @Declan Rodger
Not sure which configuration window you mean ?...do you mean the PAW admintool.sh ?.
If so, I have pointed my TM1 Application Server Gateway URI to this : http://servername:9511/tm1web​  - but it makes no difference.
Regards

------------------------------
Nick Waters
------------------------------


Original Message:
Sent: Wed November 04, 2020 10:46 AM
From: Declan Rodger
Subject: Cannot access TM1 websheets in PAW

I don't think this has been explained very well in the documentation (or at least I haven't found the correct part yet.)

In the workspace configuration window where you used to list your application server e.g. http://myapplicationserver:9510/pmpsvc
You now need to point it to your tm1 web server and port - in your case: http://servername:9511/tm1web/

That's how you tell workspace which tm1 web service to use (or spreadsheet service as well call it now) - hopefully in a future version the configuration screen will explain that bit better.

------------------------------
Declan Rodger