PAjs - Planning Analytics with Watson JavaScript REST Client

A forum to post information about tools which are free and open source.
Post Reply
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

PAjs - Planning Analytics with Watson JavaScript REST Client

Post by Edward Stuart »

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.
User avatar
WilliamSmith
Posts: 37
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

Post by WilliamSmith »

Very cool Edward!! Thank you for sharing.

Wondering if you may be available to chat about PAW.
Wim Gielis
MVP
Posts: 3105
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: PAjs - Planning Analytics with Watson JavaScript REST Client

Post by Wim Gielis »

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.
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
Post Reply