TM1 Forum

Hello all,
with version 10.2 did somenone succed in passing an element to a SUBNM cell in a websheet using the title_S#-R#-C#=element approach from the 10.1 documentation? Are there other possibilities? Would it be reliable to combine a 10.2.2 TM1Web with 10.2 Server for a transition period to make use of the improved URL API?

Thank you!

There are still a few critical components missing from the 10.2 URL API. I assume it will come in time. In the meantime there is no reason not to combine 10.1 web server using IIS/.Net with 10.2 application server.

The setup is a bit trickier (e.g. manual setup of virtual directory and application pools) if the webserver and application server are on the same machine but business as usual if the webserver is on a different machine.

You should look into the 10.2.2 release. I mithered IBM for ages asking for this functionality (_S#-R#-C#=element approach) and when 10.2.2 came out, although the time had passed for me to try and implement it, it looked from the doco that they had put it back in.

Hi,

Yes, URL API is back into action with an upgrade to 10.2.2.
We did some basic testing and the title element selection is available since that update. (10.2.2).

There is documentation available for the syntax :

http://www-01.ibm.com/support/knowledge ... ction.html

http://www-01.ibm.com/support/knowledge ... title_elem

Thank you all for your advice. We were finally waiting for 10.2.2.
An example for the above mentioned syntax on the planning sample model would be:

http://<your server>/tm1web/UrlApi.jsp#Action=Open&Type=Websheet&Workbook=Anwendungen/Planning%20Sample/Administrator/Planning%20Sample%20MDX.xls&AdminHost=fki64g&TM1Server=Planning%20Sample&UserName=admin&Password=apple&HideToolbar=False&AutoRecalc=True&title_S0-R10-C4=US

Note: The Excel cell with the SUBNM formula is in E11 - not in D10. This is a little bit hidden in the docs.

regards