Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TI process hot promotion #77

Open
wimgielis opened this issue Oct 1, 2020 · 4 comments
Open

TI process hot promotion #77

wimgielis opened this issue Oct 1, 2020 · 4 comments

Comments

@wimgielis
Copy link
Contributor

wimgielis commented Oct 1, 2020

Hi Marius,

Do we have a sample code to hot promote a TI process, that is: we provide the full path to a *.pro file and promote it as a TI process to the TM1 server ? Assuming no syntax errors in the PRO file. This would be useful since it would allow us to not bring down the TM1 server. I see different process samples but I am not sure we have a sample for this requirement.

Thanks !

Wim

@MariusWirtz
Copy link
Collaborator

Hi @wimgielis,

TM1py doesn't provide a function to build a TM1py.Process from a .pro file. If you have the process available as a JSON file somewhere, you can use the Process.from_json() function. You can read more about it here:
cubewise-code/tm1py#351

You may want to look into Pulse for TM1. Pulse can deploy .pro files to TM1 live.

@wimgielis
Copy link
Contributor Author

I'm looking to create solutions that use TI and/or tm1py. I am not reaching out to other tools like Pulse for example. The idea is that I need to quickly deploy these processes at our customers, without bouncing the server. I will investigate my options. If anyone already scripted this in Python, please leave a message. Thanks for your feedback.

@MariusWirtz
Copy link
Collaborator

So far nobody dared to write a function that turns a .pro file into a TM1py Process object (which can then be sent to TM1).

If you are keen, you could add a from_pro function to the Process class in TM1py. If you don't feel comfortable you could just open an issue/feature-request in the TM1py project and request this feature. Perhaps you are not the only one that would appreciate that feature.
https://github.com/cubewise-code/tm1py/issues

@wimgielis
Copy link
Contributor Author

Thanks. Well, my background is Excel and VBA, then I added Turbo Integrator and SQL, AutoHotKey. Only recently a bit of Python. I am now starting to use tm1py which wasn't that easy, so adding advanced Python code will not be for now. What I did, however, was creating TI processes with the old TM1 API from VBA. The reason is that I have an Excel interface to generate data-integration processes (say, copy from 1 cube to another and making selections/zeroout's, ...) and VBA and the old API translate the input into a process with hot promotion.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants