Order of TI parameters

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

Post by EvgenyT »

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:
Image

Simply change JSON around, After:
Image

Cheers

Evgeny
Attachments
Capture2.PNG
Capture2.PNG (46.59 KiB) Viewed 3452 times
Capture.PNG
Capture.PNG (47.65 KiB) Viewed 3452 times
Wim Gielis
MVP
Posts: 3120
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

Post by Wim Gielis »

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.
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
EvgenyT
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

Post by EvgenyT »

Wim 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.
Haha, guess it would work on a smaller model. Model here takes an hour to come, a small mistake in getting the order right :lol: :lol: :lol: :lol:
Wim Gielis
MVP
Posts: 3120
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

Post by Wim Gielis »

:D 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.
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
qml
MVP
Posts: 1094
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

Post by qml »

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.
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.
Kamil Arendt
Wim Gielis
MVP
Posts: 3120
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

Post by Wim Gielis »

qml 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.
Thank you Kamil. The weekend is approaching so we know what to do 😆
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
MVP
Posts: 3120
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

Post by Wim Gielis »

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