PAW information for PAX
- Ganos Lal
- Posts: 38
- Joined: Fri Oct 29, 2010 8:56 am
- OLAP Product: TM1
- Version: TM1 11
- Excel Version: 2019 + 365
- Location: Switzerland - Neuenhof
- Contact:
PAW information for PAX
Hello
Is it possible to grab information from PAW, espacially database information from Administer tab, and show it in PAX Excel Reports?
Regards,
Jani
Is it possible to grab information from PAW, espacially database information from Administer tab, and show it in PAX Excel Reports?
Regards,
Jani
End of time.
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PAW information for PAX
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.
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.
There is no OLAP database besides TM1!
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PAW information for PAX
I am interested in it. Could you share some more examples? I don't see any official documents to explain that.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.
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PAW information for PAX
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.
There is no OLAP database besides TM1!
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: PAW information for PAX
Perhaps Marius would be interested in adding it to TM1PY in his spare time...
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PAW information for PAX
I would support that motion.David Usherwood wrote: ↑Thu Jul 09, 2020 9:19 am Perhaps Marius would be interested in adding it to TM1PY in his spare time...
There is no OLAP database besides TM1!
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: PAW information for PAX
I would 3rd it
No reason tm1py can't have a module for PAW API
No reason tm1py can't have a module for PAW API
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: PAW information for PAX
With Covid-19, the holidays are different/much closer to home anyway
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PAW information for PAX
I took the liberty to create an issue over at github for that.
https://github.com/cubewise-code/tm1py/issues/276
https://github.com/cubewise-code/tm1py/issues/276
There is no OLAP database besides TM1!
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PAW information for PAX
Thanks for sharing. It would be useful if we can use python.scrumthing wrote: ↑Thu Jul 09, 2020 7:33 am Sure. But don't expect much. A colleague of mine showed me the api.
Marius, are you here and do you hear our voice? Thanks.
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PAW information for PAX
Got a response. Seems it is not going to happen.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.
There is no OLAP database besides TM1!