Express and Excel

Post Reply
Whorty1970
Posts: 6
Joined: Tue Nov 22, 2011 11:39 am
OLAP Product: Cognos BI
Version: 8.4
Excel Version: 2010

Express and Excel

Post by Whorty1970 »

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
tomok
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

Post by tomok »

Go to the search box and type in "Excel 2010". I found several threads about Excel 2010 and CX.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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

Post by ADW »

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!
Whorty1970
Posts: 6
Joined: Tue Nov 22, 2011 11:39 am
OLAP Product: Cognos BI
Version: 8.4
Excel Version: 2010

Re: Express and Excel

Post by Whorty1970 »

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.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Express and Excel

Post by rmackenzie »

Whorty1970 wrote:... very useful to know that Excel 2010 does work ...
Steady on - this is the official link (for v9.5). It doesn't mention support for Office 2010.
ADW wrote: ... Clicking active form and then using it in excel will cause excel to crash ...
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.
Robin Mackenzie
Post Reply