COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos for MS Office => Topic started by: bdjohnson1973 on 02 Jul 2012 01:47:41 PM

Title: Congos Office will not work in Powerpoint, Word
Post by: bdjohnson1973 on 02 Jul 2012 01:47:41 PM
We recently upgraded to Cognos 10.1.1 and also upgraded to the new version of Cognos Office.  I am able to connect to Cognos via PowerPoint.  I see the report tree.  When I drag a report out on to a slide it just sits there at "Retrieving report Metadata".  I also get this in Word.

I am able to do everything just fine in Excel. 

Any ideas on what the issue could be?

Brian
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: MFGF on 09 Jul 2012 09:34:53 AM
What version of MS office are you using? Is it a 32 or 64 bit instance? Have you checked it is a supported version on the conformance page?

http://www-01.ibm.com/support/docview.wss?uid=swg27022476

Regards,

MF.
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: bdjohnson1973 on 16 Jul 2012 03:32:04 PM
Hey there MF

I did check the combatibility page and we should be good to go.  I also checked with IBM support that I was using the correct versions.

thanks

brian
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: MFGF on 18 Jul 2012 08:45:49 AM
Does the report you are dragging in contain any prompts? I have seen similar issues with prompted reports...

MF.
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: Grim on 18 Jul 2012 09:28:00 AM
Ensure that BEFORE you install Cognos for MS Office, that you run the MS KB Patch that came with it.

So your steps...

1. Uninstall CfMSO
2. Run the MS KB Patch.
3. Re-install CfMSO

I believe the MS KB Patch is in the "<Extracted_folder>/go_office folder. The KB Patch folder is KB908002. Run all three executables in this folder.

extensibilityMSM.msi
lockbackRegKey.msi
office2003-kb907417sfxcab-ENU.exe
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: bdjohnson1973 on 09 Aug 2012 09:44:00 AM
Hey there

I wanted to give everyone a quick update.  We found that McAfee was blocking the .cs file from being created in the temp folder.  This was only the case when trying to connect via PowerPoint and Word.

thank you :)

brian
Title: Re: Congos Office will not work in Powerpoint, Word
Post by: Grim on 09 Aug 2012 09:58:09 AM
Cool, update the OP with [SOLVED] in the title. :)
Title: Re: Congos Office will not work in Powerpoint, Word [Solved]
Post by: bdjohnson1973 on 09 Aug 2012 01:03:25 PM
done  ;)

brian