PAjs - Planning Analytics with Watson JavaScript REST Client
After many years of talking about creating a JavaScript frontend to Planning Analytics with Watson we are finally here!
At present we have the following functionality:
- Create listing of all AdminHost(s)
- Displaying all running Models against each AdminHost
- Read Only Access (for now) for REST Api calls to ActiveConfiguration, ActiveSession, ActiveUser, Configuration, Server and many more as well as the standard objects; Chores, Cubes, Dimensions
- Hot Promotion of Processes, copy/ update/ delete processes between AdminHost/ Models
Currently working for IntegratedSecurityMode=1 or Native TM1 Security, CAMID/ Cloud security to be added in the coming weeks
The project is hosted on GitHub and is open source: https://github.com/EddStuart/PAjs
Feel free to ask questions, make suggestions and especially consider contributing to the project.
PAjs - Planning Analytics with Watson JavaScript REST Client
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
- WilliamSmith
- Posts: 44
- Joined: Tue Dec 13, 2022 8:54 pm
- OLAP Product: TM1 / PA / PAx / PAW
- Version: TM1 11
- Excel Version: 365
Re: PAjs - Planning Analytics with Watson JavaScript REST Client
Very cool Edward!! Thank you for sharing.
Wondering if you may be available to chat about PAW.
Wondering if you may be available to chat about PAW.
-
- MVP
- Posts: 3222
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: PAjs - Planning Analytics with Watson JavaScript REST Client
Hello Edward,
Thanks for sharing.
In terms of promotion of processes and chores, I experience serious time gains with the following tools I created. It’s in Excel VBA, which has disadvantages but also advantages.
- promotion from a live TM1 model to 1 or multiple other TM1 models.
- promotion from CHO and or PRO files that are sitting on disk instead of running in a model, to 1 or multiple TM1 models
- “downloading” (creating) CHO and or PRO files to disk by dumping the properties by code number in such a file
Treating a chore means also treating its called processes.
In turn, treating a process means also treating all the processes it calls or could call.
Easiest is to first create dictionaries with all objects to do, unique names in either a chore dictionary or a process dictionary or both.
Chore dictionary is easy to fill. For processes, they can be picked by the user, or called in chores, or called in other processes that are picked or called in chores. As long as you end up with 2 correct dictionaries you should be good to do. First treat processes, then chores.
It takes a while to set up but most useful later on. Certainly the first option, then the second, then the third.
Thanks for sharing.
In terms of promotion of processes and chores, I experience serious time gains with the following tools I created. It’s in Excel VBA, which has disadvantages but also advantages.
- promotion from a live TM1 model to 1 or multiple other TM1 models.
- promotion from CHO and or PRO files that are sitting on disk instead of running in a model, to 1 or multiple TM1 models
- “downloading” (creating) CHO and or PRO files to disk by dumping the properties by code number in such a file
Treating a chore means also treating its called processes.
In turn, treating a process means also treating all the processes it calls or could call.
Easiest is to first create dictionaries with all objects to do, unique names in either a chore dictionary or a process dictionary or both.
Chore dictionary is easy to fill. For processes, they can be picked by the user, or called in chores, or called in other processes that are picked or called in chores. As long as you end up with 2 correct dictionaries you should be good to do. First treat processes, then chores.
It takes a while to set up but most useful later on. Certainly the first option, then the second, then the third.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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