PAW information for PAX

Post Reply
User avatar
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

Post by Ganos Lal »

Hello

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.
User avatar
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

Post by scrumthing »

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.
There is no OLAP database besides TM1!
User avatar
macsir
MVP
Posts: 782
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

Post by macsir »

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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
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

Post by scrumthing »

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.
PAWAA.PNG
PAWAA.PNG (20.79 KiB) Viewed 4023 times
Afterwards I think the api was accessible. If not let me know and I will check for some configuration.
https://localhost:9012/pakate-agent/
PAWAA02.PNG
PAWAA02.PNG (42.2 KiB) Viewed 4023 times
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).
PAWAA03.PNG
PAWAA03.PNG (5.97 KiB) Viewed 4023 times
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!
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: PAW information for PAX

Post by David Usherwood »

Perhaps Marius would be interested in adding it to TM1PY in his spare time... :)
User avatar
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

Post by scrumthing »

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.
There is no OLAP database besides TM1!
lotsaram
MVP
Posts: 3652
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

Post by lotsaram »

I would 3rd it :D

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.
Wim Gielis
MVP
Posts: 3113
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

Post by Wim Gielis »

With Covid-19, the holidays are different/much closer to home anyway :lol:
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
User avatar
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

Post by scrumthing »

I took the liberty to create an issue over at github for that.
https://github.com/cubewise-code/tm1py/issues/276
There is no OLAP database besides TM1!
User avatar
macsir
MVP
Posts: 782
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

Post by macsir »

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. :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
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

Post by scrumthing »

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.
There is no OLAP database besides TM1!
Post Reply