Linked Picture on TM1 Web

Post Reply
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Linked Picture on TM1 Web

Post by mvaspal »

Hi,

I am interested if anyone tried to use this excel feature over the web and it ever worked.

There are two excel sheets. On the first we have some cells populated from TM1.
Then on the second tab we paste that TM1-related range with the "Linked Picture" paste option. Anytime the first sheet is updated, the picture on the second sheet updates as well, and the size is also automatically updated.

This does not work on the web (10.2.2 FP4), it seems the picture itself is being displayed but it is not a linked picture but a static, as of when it was uploaded to the web.

Thank you!
Matyas
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Linked Picture on TM1 Web

Post by tomok »

You're asking for a dynamic picture on TM1Web? I'm almost 100% certain this is not supported, nor will ever be.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Linked Picture on TM1 Web

Post by mvaspal »

correct, auto-resizing the picture box works surprisingly well in Perspectives, and we were wondering if we could use this on the web.
Anyway, we opened a service request with IBM just to confirm if this is the case.

Thanks!
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Linked Picture on TM1 Web

Post by Wim Gielis »

mvaspal wrote:auto-resizing the picture box works surprisingly well in Perspectives
That is what I would expect, this functionality and the Camera functionality are just part of Excel.
The underlying cells are filled with TM1 functions but that doesn't make any difference.

Also I'm quite sure this kind of stuff is not supported on TM1 Web, yet it could be useful.
Last edited by Wim Gielis on Wed Jan 13, 2016 2:06 pm, edited 1 time in total.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Linked Picture on TM1 Web

Post by mvaspal »

Thanks Wim for your reply,
You are right we have just tested it with a very few, non tm1-related cells and it does not work.
It could have solved our "2 active forms alongside each other" issue :)
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Linked Picture on TM1 Web

Post by lotsaram »

I regard this as a great Excel feature for building dashboards and "escaping the grid" that Excel imposes. But it is an obscure feature that is very seldom used in practice and I would be very, very surprised if it was ever supported in TM1 web.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Linked Picture on TM1 Web

Post by mvaspal »

confirmed by IBM, not supported in Web, we can create an enhancement request if we want to

thanks guys to all of you for your comments!!!
Post Reply