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!
Planning Analytics - Run TI Process Passing URL
- tianoklein
- Posts: 41
- Joined: Fri Jun 13, 2014 1:23 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
-
- 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
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.
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.
- 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
Hello BrianL,
I create a html file and nothing happen.
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>
-
- 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
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'.
- 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
Hi BrianL,
I'm no good making javascripts /JSON scripts
Am I going to the right way?
I'm no good making javascripts /JSON scripts
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>
-
- 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
Try using jquery with the $.post method.
Check the example at the bottom:
https://api.jquery.com/jquery.post/
Check the example at the bottom:
https://api.jquery.com/jquery.post/