Troubleshooting
Problem
Users getting prompted to enter username and password when attempting to login to a SSO enabled CAM authenticated server using Excel VBA.
This results in login failure over Planning Analytics server as manually entered credentials are not accepted considering Cognos Analytics is configured to use SSO.
Symptom
1)Users are presented with a windows login screen while attempting to login through Excel VBA to a Planning Analytics server configured to authenticate against a SSO enabled Cognos Analytics environment.
2)Issue does not surface when user attempts to login to the same server using Perspective's Server Explorer window.
3)Once user logs into the server using Perspective's Server Explorer window and then attempts to login using Excel VBA,logins work as expected without the user getting prompted to enter windows credentials manually.
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000blsYAAQ","label":"Troubleshooting"}],"ARM Case Number":"TS003604341","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
26 May 2020
UID
ibm16216110