COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: thart21 on 14 Sep 2012 03:04:16 PM

Title: Cognos Go! Office and Excel 2010
Post by: thart21 on 14 Sep 2012 03:04:16 PM
Hi,

Hoping someone has some experience in this as I've found nothing so far in my search.  I have installed Cognos Go! Office for Cognos v 10.1. I have Windows 7 OS, Office Excel 2010 and .NET 3.5

The add-in shows up in Excel and I am able to connect to the Cognos server but, all it will do is require me to login when I go to Browse Files. Once I login, my portal opens showing all my files in the Cognos browser window but the Browse Content window in Excel never loads.

Is this a compatibilitiy issue? I read, for 8.4, that you needed .net 2.0 but I can't install that with Windows 7.

Any ideas would be appreciated.

Thanks!

Toni
Title: Re: Cognos Go! Office and Excel 2010
Post by: Jaro2 on 16 Sep 2012 05:38:28 AM
your connectionstring is not right in combination with single signon. I presume you only have "http://server/cognos10" or something like that? If so, the login screen is given and while you login automatically you stay in that screen....

Solution: adjust your connectionstring, add "/cgi-bin/cognosisapi.dll" and it will work. (for cgi, use the cgi-string)

Title: Re: Cognos Go! Office and Excel 2010
Post by: thart21 on 17 Sep 2012 10:22:04 AM
Hi,

Thanks for replying! Below is my current connection string ("xxxx" is my company name hidden")

http://whqcognos.xxxx.com/cognos10/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/main.xts&startwel=yes&h_CAM_action=logonAs

Thanks,

Toni
Title: Re: Cognos Go! Office and Excel 2010
Post by: Jaro2 on 17 Sep 2012 11:05:32 AM
I suggest trying the conn.string like I said earlier, thus ending with cognosisapi.dll.

Are you using single singnon?
Title: Re: Cognos Go! Office and Excel 2010
Post by: thart21 on 17 Sep 2012 02:02:15 PM
Thank you! I changed the conn string to be
http://whqcognos.xxxx.com/cognos10/cgi-bin/cognosisapi.dll and now can import reports but, after running, no data shows up in my worksheet.  Will keep working with it but now, thanks to your advice, I can see my Cognos folders!

Toni