Hi
I've read that Express is not supported with Excel 2010, but is this just a case of it's not supported, or is it really a case of 2010 just won't work with Express.
If it's a mix of 'it partly works', could someone explain which parts work and which down?
Plus, does anyone know when Express will get the TM1 9.5.2 engine?
Cheers, Whorty
Express and Excel
-
- Posts: 6
- Joined: Tue Nov 22, 2011 11:39 am
- OLAP Product: Cognos BI
- Version: 8.4
- Excel Version: 2010
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Express and Excel
Go to the search box and type in "Excel 2010". I found several threads about Excel 2010 and CX.
- ADW
- Posts: 32
- Joined: Tue Jun 14, 2011 11:10 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2010
- Location: Cheshire, England
Re: Express and Excel
It is supported however there are a few issues.
1. The install program does not work. to get round this we copy the files in program files manually (back end install)
2. There a 3 main Excel functions when viewing a cube (Slice, Snapshot, and Active form). Clicking active form and then using it in excel will cause excel to crash. The other two work fine.
Other than that it is all as normal. I din't see not having active form as a massive downer!
1. The install program does not work. to get round this we copy the files in program files manually (back end install)
2. There a 3 main Excel functions when viewing a cube (Slice, Snapshot, and Active form). Clicking active form and then using it in excel will cause excel to crash. The other two work fine.
Other than that it is all as normal. I din't see not having active form as a massive downer!
-
- Posts: 6
- Joined: Tue Nov 22, 2011 11:39 am
- OLAP Product: Cognos BI
- Version: 8.4
- Excel Version: 2010
Re: Express and Excel
Thanks ADW - very useful to know that Excel 2010 does work as we are 2010 and as a smaller company full TM1 and Cog BI would be complete overkill !
I did search the site, I wasn't being completely idle, it's just that I couldn't quite work out whether 2010 did work (with some effort) or whether it just didn't work at all.
I did search the site, I wasn't being completely idle, it's just that I couldn't quite work out whether 2010 did work (with some effort) or whether it just didn't work at all.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Express and Excel
Steady on - this is the official link (for v9.5). It doesn't mention support for Office 2010.Whorty1970 wrote:... very useful to know that Excel 2010 does work ...
Active forms are extremely useful and key functionality especially if you are going to use the CX version of TM1 Web (I'm not assuming you are, but you maybe).You should ask some serious questions from IBM/ the IBM partner if you are going to buy something that will be seriously hobbled in your environment.ADW wrote: ... Clicking active form and then using it in excel will cause excel to crash ...
Robin Mackenzie