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
TM1 Web Probelm
- LeeTaylor1979
- Posts: 63
- Joined: Mon Aug 25, 2008 12:53 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2010
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 Web Probelm
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.....)
-
- Posts: 1
- Joined: Thu Aug 28, 2008 3:07 pm
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 Web Probelm
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?
However....
What were you wanting to say?
- 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
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.
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
Rizwan Kaif