websheet formatting missing Tm1 9.4

Post Reply
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

websheet formatting missing Tm1 9.4

Post by BigG »

Hi, seen a few discussions around on this but our 9.4 install (cognos express 9.0) has an issue with Tm1 web - no formatting appears on the websheet. Data is there and functionality works as expected, just no column width or cell formatting.

Most reference material to date has pointed to permissions of express_installation_location\Xcelerator\Tm1web and express_installation_location\Xcelerator\TM1WebEx allowing the default IIS user to have access. We have done this and ensured the access is inherited by each folders children folders. We have also given full access to 'everyone' for these folders as last ditch effort.

Server is 64bit and Excel 2007 (and even tried with Excel 2003 install).

Ay experiences or suggestions?

Admin : Moved from bugs to Cognos TM1
GG
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: websheet formatting missing Tm1 9.4

Post by lotsaram »

This is a security permissions issue on the server not a bug. After ensuring sufficient access to the TM1WebEx directories did you refresh IIS and have you tried restarting the server itself? (sometimes a reboot is necessary.)

Edit 24/01/2011
More info here: http://forums.olapforums.com/viewtopic. ... 863#p17863
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: websheet formatting missing Tm1 9.4

Post by BigG »

GG
Post Reply