TM1Web Websheet - Hide .xls path in browser title

Post Reply
Kingsley
Posts: 21
Joined: Tue Sep 10, 2013 3:34 pm
OLAP Product: TM1
Version: PA 2.0
Excel Version: 2016

TM1Web Websheet - Hide .xls path in browser title

Post by Kingsley »

Hello,

Is there a way to configure in Web.config to have the title in Internet Explorer show something other than the path to the file.
Currently: "Websheet - //MYSERVER/ExcelTemplates/Home.xls - Windows Internet Explorer"
Preferred: "Websheet - Home - Windows Internet Explorer"

Tested in Firefox as well. Path shows on tab.

<!-- If set, the object of type of Websheet, Cubeviewer or Url will be displayed upon user's login. -->
<add key="HomePageObject" value="//MYSERVER/ExcelTemplates/Home.xls;Type=websheet;Description=Home;AllowOverwrite=true" />

Thanks,
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1Web Websheet - Hide .xls path in browser title

Post by declanr »

Never something I've actively tried to do but as a by product of something else I was doing I have found that if you navigate to a websheet using a hyperlink() formula it will display the tab as the "friendly name".

So depending on whether you have a menu sheet and how you wish to navigate to subsequent sheets then that could do the trick for you.
Declan Rodger
Kingsley
Posts: 21
Joined: Tue Sep 10, 2013 3:34 pm
OLAP Product: TM1
Version: PA 2.0
Excel Version: 2016

Re: TM1Web Websheet - Hide .xls path in browser title

Post by Kingsley »

declanr wrote:Never something I've actively tried to do but as a by product of something else I was doing I have found that if you navigate to a websheet using a hyperlink() formula it will display the tab as the "friendly name".

So depending on whether you have a menu sheet and how you wish to navigate to subsequent sheets then that could do the trick for you.
I see what you mean but this Home.xls is my default page where it launches automatically when users log into TM1Web.

This Websheet then have multiple hyperlinks used to navigate to other Websheets. These sheets show friendly names on the title bar with no problems.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1Web Websheet - Hide .xls path in browser title

Post by declanr »

Kingsley wrote:I see what you mean but this Home.xls is my default page where it launches automatically when users log into TM1Web.

This Websheet then have multiple hyperlinks used to navigate to other Websheets. These sheets show friendly names on the title bar with no problems.
If it's a huge issue you could always go about displaying the pages through a third party tool; such as sharepoint - if I remember correctly that used to cover up the tab names.

I assume this is just due to you not wanting users to see the link between TM1 Web and it's torrid excel origins?
Declan Rodger
Kingsley
Posts: 21
Joined: Tue Sep 10, 2013 3:34 pm
OLAP Product: TM1
Version: PA 2.0
Excel Version: 2016

Re: TM1Web Websheet - Hide .xls path in browser title

Post by Kingsley »

declanr wrote:
Kingsley wrote:I see what you mean but this Home.xls is my default page where it launches automatically when users log into TM1Web.

This Websheet then have multiple hyperlinks used to navigate to other Websheets. These sheets show friendly names on the title bar with no problems.
If it's a huge issue you could always go about displaying the pages through a third party tool; such as sharepoint - if I remember correctly that used to cover up the tab names.

I assume this is just due to you not wanting users to see the link between TM1 Web and it's torrid excel origins?
I wouldn't say this is a major issue. I definitely would not go into implementing Sharepoint to this. I personally just think it takes away some of the aesthetics TM1Web offers. I was hoping it would be a simple additional line in the config file. some kind of integreated XML/HTML feature.

ie: <a href="http://www.homepage.com">Click here to go Home</a>

Guess not?
Post Reply