TM1 10.2 URL API websheet title elements

Post Reply
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

TM1 10.2 URL API websheet title elements

Post by Marcus Scherer »

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!
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 10.2 URL API websheet title elements

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: TM1 10.2 URL API websheet title elements

Post by rmackenzie »

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.
Robin Mackenzie
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: TM1 10.2 URL API websheet title elements

Post by Olivier »

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
HTH
Olivier
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: TM1 10.2 URL API websheet title elements

Post by Marcus Scherer »

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