Topic
  • 3 replies
  • Latest Post - ‏2013-02-20T16:30:00Z by DanielWagemann
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic IBM Cognos 8 for Microsoft Office - VBA Logon

‏2013-02-15T04:35:03Z |
For anyone using VBA to trigger Cognos Go Office events (such as automation of report refresh), does the vba logon object support single signon?

The documentation for signing on shows the following example:

Dim bRresult As Boolean
bResult = CognosOfficeAutomationObject.Logon("http://localhost/cognos8/cgi-bin/cognos.cgi",
"Administrator", "CognosAdmin", "Production")

There doesn't appear to be any obvious way to sign using your AD logon credentials.
Updated on 2013-02-20T16:30:00Z at 2013-02-20T16:30:00Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: IBM Cognos 8 for Microsoft Office - VBA Logon

    ‏2013-02-15T13:18:21Z  
    Are you trying to sign on to AD using SSO or do you have an AD namespace where a user would type in their UID and PWD?
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: IBM Cognos 8 for Microsoft Office - VBA Logon

    ‏2013-02-17T22:45:50Z  
    Are you trying to sign on to AD using SSO or do you have an AD namespace where a user would type in their UID and PWD?
    Hi Daniel,

    Trying to sign on using SSO.

    Peter
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: IBM Cognos 8 for Microsoft Office - VBA Logon

    ‏2013-02-20T16:30:00Z  
    Hi Daniel,

    Trying to sign on using SSO.

    Peter
    As a test you could try leaving out the UID and PWD to see if it gets picked up.
    bResult = CognosOfficeAutomationObject.Logon("http://localhost/cognos8/cgi-bin/cognos.cgi",,, "Production")

    OR

    bResult = CognosOfficeAutomationObject.Logon("http://localhost/cognos8/cgi-bin/cognos.cgi",
    "", "", "Production")

    If that does not work you could install another gateway or point directly to a dispatcher where the SSO is disabled and requires a UID and PWD.