TM1 Web Probelm

Post Reply
User avatar
LeeTaylor1979
Posts: 63
Joined: Mon Aug 25, 2008 12:53 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

TM1 Web Probelm

Post by LeeTaylor1979 »

Are there any Tm1 web experts who can please help me with the following.

I have published 2 new Excel spread sheets in applications.

When trying to open them this is what i get:

"Error ocurred while converting the MS excel workbook into XML format: Server Execution failed"

Spread sheets that were already publish are fine and open up straight away.

Can anyone please help ?

Kind regards


Lee
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Web Probelm

Post by David Usherwood »

Worth checking if the TM1 Excel Service is running. My belief is that that renders the Excel worksheets when you publish (unlike TM1Web 8, which did it on the fly.... very.... slowly.....)
rbiederman
Posts: 1
Joined: Thu Aug 28, 2008 3:07 pm

Re: TM1 Web Probelm

Post by rbiederman »

ronald biederman
www.revelwood.com
201-984-3028
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Web Probelm

Post by David Usherwood »

Hi and welcome to the forum. I think you are the first Revelwood person to post. Give my regards to Dan.
However....
What were you wanting to say?
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: TM1 Web Probelm

Post by rkaif »

I have seen this error before.

I got this eror as I was using Active Button in my Excel spreasheet. When I try to open the sheet in TM1Web it gave me this error. All those spreadsheets which do not have Active Button can be opened easily in TM1 web.

Solution:

Active Buttons will not work over the TM1Web if the TM1XL.OCX file is not registered within MS Windows.

You can register it using the following command:
RegSvr32 “C:\Program Files (x86)\Cognos\TM1\bin\tm1xl.ocx”

Hope it helps.
Cheers!
Rizwan Kaif
Post Reply