I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Hi,

I just checked the Supported Environments page for 11.1.7, and Office 365 is a supported version for Cognos for MS Office. There are some notes that you might want to check out:

Please note that the bit version of Office which you are running must match the bit version of Cognos for Microsoft Office installed. If you are running 32bit Microsoft Office, you must install the 32bit version of Cognos for Microsoft Office.

Cognos Office Connection integration is only supported on Windows platforms.

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Mark,

I did take note of it and installed .net framwork 4.8. It happened inspite of it.

Best Regards,

Hi,

I just checked the Supported Environments page for 11.1.7, and Office 365 is a supported version for Cognos for MS Office. There are some notes that you might want to check out:

Please note that the bit version of Office which you are running must match the bit version of Cognos for Microsoft Office installed. If you are running 32bit Microsoft Office, you must install the 32bit version of Cognos for Microsoft Office.

Cognos Office Connection integration is only supported on Windows platforms.

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Quick sanity check - you did configure your gateway URL then go through the sign-in process, right? Did the authentication process go through ok?

Cheers!

MF.

Mark,

I did take note of it and installed .net framwork 4.8. It happened inspite of it.

Best Regards,

Hi,

I just checked the Supported Environments page for 11.1.7, and Office 365 is a supported version for Cognos for MS Office. There are some notes that you might want to check out:

Please note that the bit version of Office which you are running must match the bit version of Cognos for Microsoft Office installed. If you are running 32bit Microsoft Office, you must install the 32bit version of Cognos for Microsoft Office.

Cognos Office Connection integration is only supported on Windows platforms.

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Hi Mark,

The authentication process is going ok as evident when using the 'Connection' and 'Open' links in the ribbon above. On authentication from the 'Open'

link, I get to enter the credentials but it simply opens up the Cognos portal and if I close the portal the dialog box box appears (second image). The pane on the extreme right which is supposed to display cognos content is still empty.

Best Regards,

------------------------------
Mack L

Original Message:
Sent: Wed February 14, 2024 10:47 AM
From: Mark Fry
Subject: IBM Cognos for Microsoft Office not working as expected

Quick sanity check - you did configure your gateway URL then go through the sign-in process, right? Did the authentication process go through ok?

Cheers!

MF.

------------------------------
Mark Fry
Technical Consultant

Original Message:
Sent: Wed February 14, 2024 10:39 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

Mark,

I did take note of it and installed .net framwork 4.8. It happened inspite of it.

Best Regards,

------------------------------
Mack L

Original Message:
Sent: Wed February 14, 2024 10:10 AM
From: Mark Fry
Subject: IBM Cognos for Microsoft Office not working as expected

Hi,

I just checked the Supported Environments page for 11.1.7, and Office 365 is a supported version for Cognos for MS Office. There are some notes that you might want to check out:

Please note that the bit version of Office which you are running must match the bit version of Cognos for Microsoft Office installed. If you are running 32bit Microsoft Office, you must install the 32bit version of Cognos for Microsoft Office.

Cognos Office Connection integration is only supported on Windows platforms.

------------------------------
Mark Fry
Technical Consultant

Original Message:
Sent: Wed February 14, 2024 04:47 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

------------------------------
Mack L
------------------------------

Hi Mark,

The authentication process is going ok as evident when using the 'Connection' and 'Open' links in the ribbon above. On authentication from the 'Open'

link, I get to enter the credentials but it simply opens up the Cognos portal and if I close the portal the dialog box box appears (second image). The pane on the extreme right which is supposed to display cognos content is still empty.

Best Regards,

------------------------------
Mack L

Original Message:
Sent: Wed February 14, 2024 10:47 AM
From: Mark Fry
Subject: IBM Cognos for Microsoft Office not working as expected

Quick sanity check - you did configure your gateway URL then go through the sign-in process, right? Did the authentication process go through ok?

Cheers!

MF.

Mark,

I did take note of it and installed .net framwork 4.8. It happened inspite of it.

Best Regards,

Hi,

I just checked the Supported Environments page for 11.1.7, and Office 365 is a supported version for Cognos for MS Office. There are some notes that you might want to check out:

Please note that the bit version of Office which you are running must match the bit version of Cognos for Microsoft Office installed. If you are running 32bit Microsoft Office, you must install the 32bit version of Cognos for Microsoft Office.

Cognos Office Connection integration is only supported on Windows platforms.

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

------------------------------
Mack L
------------------------------

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Thank you Mark/Han/Karas, 

Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right.

I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing another hurdle. When I click on the plus sign to view the cognos content, I am prompted for credentials and when I enter them, I get no response (see screenshots). Not able to go beyond this. Please suggest.

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

How is authentication set up on your Cognos Analytics instance? Are you using Single Sign On (SSO)? I found an article that covers resolving endless authentication loops in Cognos for MS Office with SSO, but not sure if this is your situation?

https://www.ibm.com/support/pages/cognos-microsoft-office-go-office-prompts-login-screen-repeatedly

Cheers!

MF.

Thank you Mark/Han/Karas, 

Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right.

I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing another hurdle. When I click on the plus sign to view the cognos content, I am prompted for credentials and when I enter them, I get no response (see screenshots). Not able to go beyond this. Please suggest.

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

Thank you for the suggestion. I will surely try it out but a question please - does Cognos for microsoft office have its own version that should be compatible with the version of Cognos that is being used?. Please let me know.

We are using Cognos 11.1.7 and I am trying out the Cognos for MS office app on my device after getting the software from the IBM portal by the admin.

Best Regards,

How is authentication set up on your Cognos Analytics instance? Are you using Single Sign On (SSO)? I found an article that covers resolving endless authentication loops in Cognos for MS Office with SSO, but not sure if this is your situation?

https://www.ibm.com/support/pages/cognos-microsoft-office-go-office-prompts-login-screen-repeatedly

Cheers!

MF.

Thank you Mark/Han/Karas, 

Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right.

I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing another hurdle. When I click on the plus sign to view the cognos content, I am prompted for credentials and when I enter them, I get no response (see screenshots). Not able to go beyond this. Please suggest.

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

How is authentication set up on your Cognos Analytics instance? Are you using Single Sign On (SSO)? I found an article that covers resolving endless authentication loops in Cognos for MS Office with SSO, but not sure if this is your situation?

https://www.ibm.com/support/pages/cognos-microsoft-office-go-office-prompts-login-screen-repeatedly

Cheers!

MF.

------------------------------
Mark Fry
Technical Consultant

Original Message:
Sent: Mon February 19, 2024 10:53 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

Thank you Mark/Han/Karas, 

Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right.

I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing another hurdle. When I click on the plus sign to view the cognos content, I am prompted for credentials and when I enter them, I get no response (see screenshots). Not able to go beyond this. Please suggest.

------------------------------
Mack L

Original Message:
Sent: Thu February 15, 2024 10:17 AM
From: Mark Karas
Subject: IBM Cognos for Microsoft Office not working as expected

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

------------------------------
Mark Karas

Original Message:
Sent: Wed February 14, 2024 04:47 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

------------------------------
Mack L
------------------------------

Hi Mark,

I tried what you suggested i.e., setting the  'Allow session information to be shared between client applications? property to true in Cognos Configuration but still have the same problem when I click the plus sign in the right pane, getting prompted again for credentials and on entering the credentials and logging in, nothing happens. Please suggest if I can try anything else.

Another thing observed is that the above happens when I try one url (we have two urls that point to the same cognos server). When I try the second url (took care to use the ....... /v1/Disp format), I get the following error:

AAA-AUT-0013:  The User is already authenticated in all available namespaces

Best Regards,

------------------------------
Mack L

Original Message:
Sent: Mon February 19, 2024 12:56 PM
From: Mark Fry
Subject: IBM Cognos for Microsoft Office not working as expected

How is authentication set up on your Cognos Analytics instance? Are you using Single Sign On (SSO)? I found an article that covers resolving endless authentication loops in Cognos for MS Office with SSO, but not sure if this is your situation?

https://www.ibm.com/support/pages/cognos-microsoft-office-go-office-prompts-login-screen-repeatedly

Cheers!

MF.

------------------------------
Mark Fry
Technical Consultant

Original Message:
Sent: Mon February 19, 2024 10:53 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

Thank you Mark/Han/Karas, 

Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right.

I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing another hurdle. When I click on the plus sign to view the cognos content, I am prompted for credentials and when I enter them, I get no response (see screenshots). Not able to go beyond this. Please suggest.

------------------------------
Mack L

Original Message:
Sent: Thu February 15, 2024 10:17 AM
From: Mark Karas
Subject: IBM Cognos for Microsoft Office not working as expected

Try changing to Optimize for Compatibility mode:

https://www.ibm.com/support/pages/ibm-cognos-microsoft-office-11-connection-using-office-2016-excel%E2%84%A2-powerpoint-%E2%84%A2-word-%E2%84%A2-login-blank-page-post-window-%C2%AE10-build-1809-update

Regards, Mark

------------------------------
Mark Karas

Original Message:
Sent: Wed February 14, 2024 04:47 AM
From: Mack L
Subject: IBM Cognos for Microsoft Office not working as expected

I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal  url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank.

The Cognos version I am using is 11.1.7 and office is 365. I have also played around with 'options' available in the Ribbon but could not get it working.

Please suggest.

Best Regards,

------------------------------
Mack L
------------------------------