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 4849 times
Capture.PNG
Capture.PNG (47.65 KiB) Viewed 4849 times
Wim Gielis
MVP
Posts: 3234
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: 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-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
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: 3234
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: 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-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
User avatar
qml
MVP
Posts: 1096
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: 3234
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: 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-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
MVP
Posts: 3234
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: 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-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
Post Reply