Hi,
If you are as pedantic about your TI parameters order as I am, you have probably found yourself deleting and recreating parameters many times.
This limitation can be easily solved with PATCHing your TI via Rest API.
Before:
Simply change JSON around, After:
Cheers
Evgeny
Order of TI parameters
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Order of TI parameters
- Attachments
-
- Capture2.PNG (46.59 KiB) Viewed 4005 times
-
- Capture.PNG (47.65 KiB) Viewed 4005 times
-
- MVP
- Posts: 3182
- 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: Order of TI parameters
Indeed, I figured this out too. Call me pedantic too.
Before this, I used to open the PRO file in Notepad++, do a couple of Ctrl-Shift-Arrow up/down gestures, save/close the PRO file, restart TM1.
Still more handy than the doing it in the Parameters section of the process in Turbo Integrator.
Before this, I used to open the PRO file in Notepad++, do a couple of Ctrl-Shift-Arrow up/down gestures, save/close the PRO file, restart TM1.
Still more handy than the doing it in the Parameters section of the process in Turbo Integrator.
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
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: Order of TI parameters
Haha, guess it would work on a smaller model. Model here takes an hour to come, a small mistake in getting the order rightWim Gielis wrote: ↑Thu Dec 12, 2019 11:27 pm Indeed, I figured this out too. Call me pedantic too.
Before this, I used to open the PRO file in Notepad++, do a couple of Ctrl-Shift-Arrow up/down gestures, save/close the PRO file, restart TM1.
Still more handy than the doing it in the Parameters section of the process in Turbo Integrator.
-
- MVP
- Posts: 3182
- 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: Order of TI parameters
Indeed, it’s only workable for small TM1 models.
A question. In an environment without Postman (and TM1py and the likes), can we execute a REST API call by simply using a browser ? For example, a statement like the above. I know that simple GET requests like a list of cubes are easy in a browser but not sure about more advanced queries where additional headers are needed or body.
A question. In an environment without Postman (and TM1py and the likes), can we execute a REST API call by simply using a browser ? For example, a statement like the above. I know that simple GET requests like a list of cubes are easy in a browser but not sure about more advanced queries where additional headers are needed or body.
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
- qml
- MVP
- Posts: 1095
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Order of TI parameters
Anything in a browser's address bar is a GET request, so you can't do other request types that way. However, if you can add a browser extension in your environment then there are quite a few REST extensions to choose from with full functionality. For Chrome I can recommend Advanced REST Client.Wim Gielis wrote: ↑Fri Dec 13, 2019 7:44 am A question. In an environment without Postman (and TM1py and the likes), can we execute a REST API call by simply using a browser ? For example, a statement like the above. I know that simple GET requests like a list of cubes are easy in a browser but not sure about more advanced queries where additional headers are needed or body.
Kamil Arendt
-
- MVP
- Posts: 3182
- 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: Order of TI parameters
Thank you Kamil. The weekend is approaching so we know what to doqml wrote: ↑Fri Dec 13, 2019 9:48 am Anything in a browser's address bar is a GET request, so you can't do other request types that way. However, if you can add a browser extension in your environment then there are quite a few REST extensions to choose from with full functionality. For Chrome I can recommend Advanced REST Client.
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
-
- MVP
- Posts: 3182
- 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: Order of TI parameters
I like the Advanced REST client, thanks Kamil.
@lotsaram: maybe it's worth adding this to the REST API page(s) on your company's website, to complement Postman.
To me this Chrome extension is a lightweight solution in cases where Postman, or any other such installation, on a corporate system is not possible.
@lotsaram: maybe it's worth adding this to the REST API page(s) on your company's website, to complement Postman.
To me this Chrome extension is a lightweight solution in cases where Postman, or any other such installation, on a corporate system is not possible.
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