Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  PAX API - Any way to check if connection is active?

    Posted Wed April 17, 2019 04:21 PM
    Edited by System Admin Fri January 20, 2023 04:38 PM
    Hello Everyone,

    I've been using PAX for a little while, including the VBA API. The documentation found here: https://ibm.github.io/paxapi/#introduction is quite helpful but did have a question.

    Is there a call to check whether the user is connected? Do want to prevent the triggering of some of my VBA code if the end-user is not connected.

    Thank you.

    ------------------------------
    Adam
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: PAX API - Any way to check if connection is active?

    Posted Wed May 15, 2019 09:02 AM
    Edited by System Admin Fri January 20, 2023 04:46 PM
    Hello,

    I wanted to share that I've discovered that I can run Application.Run("TM1User", "tm1")
    If a user is connected it will return their username.
    If a user is disconnected it will return a blank.
    Hope others can benefit from this.

    ------------------------------
    Adam
    ------------------------------

    Original Message


  • 3.  RE: PAX API - Any way to check if connection is active?

    Posted Wed May 15, 2019 10:32 AM

    Hi Adrian,

    • There is no easy way because PA for Excel is a local installation. The only way would be looking at individual computer at the .com files for excel
    • What version of PA for excel are you using? There has been allot of changes to PA for Excel -https://www-01.ibm.com/support/docview.wss?uid=swg27049597
    • Are you seeing issues with user or are the issues widespread? You could look at doing at https://www.telerik.com/fiddler
    • Users have also changed settings like compatibility mode as part of working with PA for Excel
    • Users could also be doing other things beyond working with TM1 as such those things need to be consider when assessing issues with PA and Excel

     

     



    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 4.  RE: PAX API - Any way to check if connection is active?

    Posted Wed May 15, 2019 10:49 AM
    Hi Paul,

    Adam will work. :-)

    It's not an issue I am facing, otherwise I would've filed a case with the technical support team. I mention this because your message is more so oriented toward troubleshooting.

    I've built a model using IBM PA for Excel. Using the API documentation located here: https://ibm.github.io/paxapi/#introduction I've been able to automate a significant portion of the Excel end-user experience. 

    My question is whether or not an IBM PAX API call exists to check if the user in Excel is connected to IBM PA. I am using the latest version, PAX 2.0.42.

    Through my research I've only found (message #2 above) to work.​

    ------------------------------
    Adam
    ------------------------------

    Original Message


Related Content