TM1 Forum

Hello

Is it possible to grab information from PAW, espacially database information from Administer tab, and show it in PAX Excel Reports?

Regards,
Jani

You could try using the Planning Analytics Adminstration Agent API to get some of the information.
https://www.ibm.com/support/knowledgece ... l_paa.html

After installing it just call the api (example: https://localhost:9012/pakate-agent/) on the tm1 server in a browser.

scrumthing wrote: ↑Wed Jul 08, 2020 11:41 am installing it just call the api (example: https://localhost:9012/pakate-agent/) on the tm1 server in a browser.

I am interested in it. Could you share some more examples? I don't see any official documents to explain that.

macsir wrote: ↑Wed Jul 08, 2020 10:51 pm I am interested in it. Could you share some more examples? I don't see any official documents to explain that.

Sure. But don't expect much. A colleague of mine showed me the api.
First you have to install the PAW Adminsistration Agent which allows PAW to get the information presented in the new administration window. Afterwards I think the api was accessible. If not let me know and I will check for some configuration.
https://localhost:9012/pakate-agent/ You can do all kind of fancy stuff via that api like creating and restarting and deleting instances and retrieve benchmarks for your instance (i.e. cpu usage, memory). You can get logfiles, upload files to the server...
Looks very promising. Let me know if that helped.

Perhaps Marius would be interested in adding it to TM1PY in his spare time...

David Usherwood wrote: ↑Thu Jul 09, 2020 9:19 am Perhaps Marius would be interested in adding it to TM1PY in his spare time...

I would support that motion.

I would 3rd it

No reason tm1py can't have a module for PAW API

With Covid-19, the holidays are different/much closer to home anyway

I took the liberty to create an issue over at github for that.
https://github.com/cubewise-code/tm1py/issues/276

scrumthing wrote: ↑Thu Jul 09, 2020 7:33 am Sure. But don't expect much. A colleague of mine showed me the api.

Thanks for sharing. It would be useful if we can use python.
Marius, are you here and do you hear our voice? Thanks.

Hi @scrumthing,

I don't think this is something we would add to TM1Py. We really want to focus on the server REST API and I am not sure accessing the PA agent is documented or officially supported.

Got a response. Seems it is not going to happen.