TM1 web - fail to export websheet to pdf and excel

Post Reply
sfnicole
Posts: 20
Joined: Wed Dec 02, 2009 2:27 am
OLAP Product: TM1, Cognos
Version: 9.5.1
Excel Version: 2007
Location: Singapore

TM1 web - fail to export websheet to pdf and excel

Post by sfnicole »

Hi,
When I tried to export the websheet to PDF, the pop up screen prompt me choose the dimension. After select the dimension and click OK button, no file being export. Excel also having the same issue

Do you have any solution on it?

Thanks.
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: TM1 web - fail to export websheet to pdf and excel

Post by Martin Erlmoser »

-restart tm1excelservice & try again
-server os?
if 64bit os, installed pdfcamp correctly? are no sessions (rdp, console) active?
-Browser version? maybe try another one, other client.

maybe you should give us more informations about your tm1system.
sfnicole
Posts: 20
Joined: Wed Dec 02, 2009 2:27 am
OLAP Product: TM1, Cognos
Version: 9.5.1
Excel Version: 2007
Location: Singapore

Re: TM1 web - fail to export websheet to pdf and excel

Post by sfnicole »

Have tried to change the Internet option's setting. The problem still persists.
sfnicole
Posts: 20
Joined: Wed Dec 02, 2009 2:27 am
OLAP Product: TM1, Cognos
Version: 9.5.1
Excel Version: 2007
Location: Singapore

Re: TM1 web - fail to export websheet to pdf and excel

Post by sfnicole »

I've tested on different version of IE. It seems like it is working on IE 6 but not in IE 7.

Fyi, I've done the followings in IE7: -
1. Tools --> Internet Options --> Security --> Internet zone --> Custom Level --> File Download --> Enable
2. Tools --> Internet Options --> Security --> Local Intranet/Internet zone --> Custom Level --> Miscellaneous --> allow websites to open windows without address or status bars --> Enable
3. Tools->Internet Options --> Security --> Internet --> Custom Level --> Downloads --> Automatic prompting for file downloads --> Enable
4. Tools --> Internet Options --> Security --> Internet --> Custom Level --> Miscellaneous --> Allow script initiated windows without size or position constraints --> Enable

However, it still not working.

Have anyone of you having the same problem before? Thanks.
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: TM1 web - fail to export websheet to pdf and excel

Post by AmbPin »

Hello,

I have had that problem with several users, in most cases it was caused by a pop-up blocker. After you press OK on the button does the pop-up blocker appear briefly at the bottom of the browser.
If they have Google toolbar installed, I would suggest getting rid of that.
hbell
Posts: 61
Joined: Wed Feb 25, 2009 6:15 pm
Version: 9.1 SP3
Excel Version: 11.8

Re: TM1 web - fail to export websheet to pdf and excel

Post by hbell »

Check that PDFCamp printer driver is properly installed and is the default printer on the web server. Check that the service account for the TM1 Excel Service on the web server has local admin rights on the server as it needs to write to the registry.
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 web - fail to export websheet to pdf and excel

Post by lotsaram »

There is also a well known (but not very well documented) bug where any export to Excel or PDF from TM1 web will fail if there is any rdp session open on the server.

This is really annoying but at least you can control it in a production environment by ensuring that rdp sessions are verboten.
hbell
Posts: 61
Joined: Wed Feb 25, 2009 6:15 pm
Version: 9.1 SP3
Excel Version: 11.8

Re: TM1 web - fail to export websheet to pdf and excel

Post by hbell »

.. what does "RDP" stand for?
mykill
Posts: 11
Joined: Thu Jun 26, 2008 12:07 pm
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2010
Location: Germany

Re: TM1 web - fail to export websheet to pdf and excel

Post by mykill »

RDP = remote desktop connection
Post Reply