IBM Business Analytics

 View Only

  • 1.  IBM Planning Analytics Excel Automation

    Posted Tue May 14, 2024 05:15 PM

    Hello,

    We have Planning Analytics.  And we are trying to use its API to get some data.  My initial search resulted in this page Introduction – PAx API (ibm.github.io), and it is suggested we get CognosOfficeAutomationExample.bas.  

    1. I thought Cognos is different from Planning Analytics.  Are they interchangeable, so the .bas file would be helpful?

    2. Is there any administrative requirements (such as our Planning Analytics admin needs to enable something?) 

    3. It appears there are API (REST API and scripts?) we can use to directly getting data our of Planning Analytics database.  In comparison to using Excel macro, is there any benefit of using REST and scripts?

    Thanks

    Quin



    ------------------------------
    Quin Kan
    ------------------------------


  • 2.  RE: IBM Planning Analytics Excel Automation

    Posted Wed May 15, 2024 09:39 AM
    Unless you want to automate excel based interactions the PAfE api is not what you want. "Cognos" is just a hold over term from an older version of the plugin. I would look at using the API directly. A good place to start is TM1py. There are many good examples of how to use the wrapper and the community is very involved in maintaining the repo.





  • 3.  RE: IBM Planning Analytics Excel Automation

    Posted Mon May 20, 2024 05:32 PM

    Thanks for your information, Ryan.  Good to know there is TM1py.  I was looking for information on Excel macro because there are much more users who know Excel than Python, and it would be easier for them to change/maintain if they so choose to.  Best regards.



    ------------------------------
    Quin Kan
    ------------------------------

    Original Message


  • 4.  RE: IBM Planning Analytics Excel Automation

    Posted Mon May 20, 2024 05:45 PM

    I think it depends on who/what needs the data. Python is clearly better for system to system interaction. End users that need data typically don't need to understand how the API works as the plugin deals with all of that.




    Original Message


Related Content