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:
Sent: 5/20/2024 5:32:00 PM
From: Quin Kan
Subject: RE: IBM Planning Analytics Excel Automation
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:
Sent: Wed May 15, 2024 09:38 AM
From: Ryan Clapp
Subject: IBM Planning Analytics Excel Automation
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.
Original Message:
Sent: 5/14/2024 3:47:00 PM
From: Quin Kan
Subject: IBM Planning Analytics Excel Automation
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
------------------------------