Planning Analytics - Run TI Process Passing URL

Post Reply
User avatar
tianoklein
Posts: 41
Joined: Fri Jun 13, 2014 1:23 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Planning Analytics - Run TI Process Passing URL

Post by tianoklein »

Hello Folks,
As we can see, the Planning Analytics can't run a TI process natively (only using a sheet in perspectives).
Anyone knows if have a way to run a process using a URL? Any advice to run a TI process via portal?

I tried to use the link below, but no sucess.
https://www.ibm.com/developerworks/comm ... 08f8fc2eff

Thanks!
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Planning Analytics - Run TI Process Passing URL

Post by BrianL »

What errors are you getting when following those instructions?

It's important to note that just using a URL like that in a browser link won't work. The browser will make a GET request while the API requires a POST request with a body.
User avatar
tianoklein
Posts: 41
Joined: Fri Jun 13, 2014 1:23 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Planning Analytics - Run TI Process Passing URL

Post by tianoklein »

Hello BrianL,
I create a html file and nothing happen. :(


Code: Select all

<html>
<body>
<form action="https://_HOST_:_PORT_/tm1/api/v1/Processes('testP')/tm1.Execute"  method="post">
<button type="submit">Submit</button><br>
</form>
</body>
</html>
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Planning Analytics - Run TI Process Passing URL

Post by BrianL »

The HTML form POST action does not allow arbitrary body text or even JSON formatted body text. That's why your example isn't working. Javascript is probably your best bet. Try googling 'javascript POST JSON'.
User avatar
tianoklein
Posts: 41
Joined: Fri Jun 13, 2014 1:23 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Planning Analytics - Run TI Process Passing URL

Post by tianoklein »

Hi BrianL,
I'm no good making javascripts /JSON scripts :cry:
Am I going to the right way?

Code: Select all

<html>
<body>
<script>
var text = '{"name":"Processes","kind":"EntitySet","url":"https://_host_:_port_/tm1/api/v1/Processes('test')/tm1.Execute"}';
var obj = JSON.parse(text);
</script>

<form action="obj" method="POST">
<button type="submit">Submit</button><br>
</form>
</body>
</html>
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: Planning Analytics - Run TI Process Passing URL

Post by dr.nybble »

Try using jquery with the $.post method.

Check the example at the bottom:

https://api.jquery.com/jquery.post/
Post Reply