Unable to use Websheet in PAW

Post Reply
Emixam
Regular Participant
Posts: 156
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Unable to use Websheet in PAW

Post by Emixam »

Hello,

We have a bunch of Websheets that are working perfectly fine in TM1Web (PASS), Perspective and/or PAx. However, when I drag-and-drop the websheet in a book in PAW, it takes 30 seconds to load and the websheet is blank and there is nothing I can do.

Here is all the versions I'm using:
  • PA: 2.0.9.4
  • PAW: 2.0.59
  • PAX: 2.0.60
I tried to upload Slice from Perspective, Dynamic report from PAX and just a plain excel file and the result is always a blank window. Any idea what's going on ?

Thanks !
Attachments
blank_PAW.png
blank_PAW.png (149.38 KiB) Viewed 4127 times
blank_tm1web.png
blank_tm1web.png (18.13 KiB) Viewed 4127 times
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Unable to use Websheet in PAW

Post by declanr »

What are your configuration settings in PAW? Since TM1 Web has been split out you need to have the paw.ps1 variable below set to point to your TM1 Web Service:

Code: Select all

$env:TM1ApplicationsLocation=<WebServer:Port>
If you use the admin tool this is the setting that is deceptively called "TM1 Application Server Gateway URI" but really it is asking for your TM1 Web server and port so that it can render websheets. Also note that when you validate it will give an error but just proceed and go to PAW to test web sheets work, if they do then you have it right.
Declan Rodger
Emixam
Regular Participant
Posts: 156
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: Unable to use Websheet in PAW

Post by Emixam »

Thank you !

If anyone need more information:
https://community.ibm.com/community/use ... gestviewer
Post Reply