TM1 Forum

Hi,
I meet an upgrade issue from TM1 10.1 to TM1 10.2.2 about web url api.

In TM1 10.1, I have a hyperlink:
http://ServerName/tm1web/TM1WebMain.asp ... 2016.100.1
It open websheet base on title.

Following TM1 Version 10.2.2 Developer Guide (Page 186).
Code change as below:
http://<servername>:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&TM1Server=<ProjectName&AdminHost=<servername>&AccessType=PUBLIC&Workbook=Applications/<project_shortcode>/websheet_1_tp&title_S1-R33-C2=2015.2016.1

It open websheet but always maintains the current state of the object (ie. If I create 3 hypelinks (2015.2016.100.1, 2015.2016.100.2, 2015.2016.100.3), I click any of three links, it always open latest 2015.2016.100.3.

I guess I don't really understand the part(Page 186: Replace the ObjectID parameter Update your code anywhere you used the ObjectID parameter to track objects that you opend ....)
Who can help?
Much appreciated in advance.

FYI.
The solution is: &Title_<DimensionName> replace &title_S1-R33-C2
Cheers,

Brian_Q wrote:FYI.
The solution is: &Title_<DimensionName> replace &title_S1-R33-C2
Cheers,

Thanks for sharing the solution.
I worked with TM1Web URL API in previous version ( 10.1 ), and when I checked this in 10.2.2, I noticed that everytime you click on a hyperlinked cell in TM1Web, it opens a new browser session. Is there any workaround for this?

Thanks again!

Brian_Q wrote:FYI.
The solution is: &Title_<DimensionName> replace &title_S1-R33-C2
Cheers,

The Title_S#-R#-C# syntax is still valid, but the #s are now zero based. Changing the link to S0-R32-C1 would probably work.

Andy Key wrote:

Brian_Q wrote:FYI.
The solution is: &Title_<DimensionName> replace &title_S1-R33-C2
Cheers,

The Title_S#-R#-C# syntax is still valid, but the #s are now zero based. Changing the link to S0-R32-C1 would probably work.

It doesn't work because Title_S#-R#-C# (static) would make multi hyperlinks point to the same websheet page, however Title_<dimension> will control hyperlink point to specific page dynamically.
Thanks for your comments anyway.

ardi wrote:

Brian_Q wrote:FYI.
The solution is: &Title_<DimensionName> replace &title_S1-R33-C2
Cheers,

Thanks for sharing the solution.
I worked with TM1Web URL API in previous version ( 10.1 ), and when I checked this in 10.2.2, I noticed that everytime you click on a hyperlinked cell in TM1Web, it opens a new browser session. Is there any workaround for this?

Thanks again!

Hi,
I asked IBM for it without any solution. I personally think 10.2.2 using JAVA based web server which doesn't support objectID, then it's going to open a new browser session by design.
My application meet the same issue, I couldn't find any workaround.

With 10.2.2
Use the hyperlink in Excel and it will open the link websheet under a new tab.

=HYPERLINK("TM1://ServerName/blob/PUBLIC/.\}Externals\workbook_system_name.xlsx","my link")

Note that you need to find the system name of the Websheet. Either open the blob file or look at the websheet property.
Definitely working method as someone asked me this yesterday and I demo it.