Planning Analytics

 View Only
Expand all | Collapse all

Executing TI Process from VBA

  • 1.  Executing TI Process from VBA

    Posted Thu December 02, 2021 06:29 PM
    Using PAW on cloud and want to run a TI process from a VBA module. I see this instruction for the ExecuteFunction command:
    ExecuteFunction – PAx API (ibm.github.io)

    I think I have the wrong host name and port. Where can I find that for my server? I am looking in the welcome kit but not finding it.

    Thanks



    ------------------------------
    Ivan Cepero
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Executing TI Process from VBA

    Posted Thu December 09, 2021 11:22 AM

    Host detail (first arg in the function) should match the datasource that you have configured as a connection for PA for Excel in the connections screen.

    In general terms, that should be the same as the website you use to connect to PA Workspace in your browser.

    Let us know if it's not working for you.

    Regards



    ------------------------------
    Ted Phillips
    ------------------------------



  • 3.  RE: Executing TI Process from VBA

    Posted Wed January 05, 2022 02:01 PM
    Edited by System Fri January 20, 2023 04:13 PM