Cognos Go! Office and Excel 2010

[thart21]

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

[Jaro2]

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)

[thart21]

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

[Jaro2]

I suggest trying the conn.string like I said earlier, thus ending with cognosisapi.dll.

Are you using single singnon?

[thart21]

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