Excel tab colour when published to TM1 web

Post Reply
smantrip
Posts: 7
Joined: Sat Apr 26, 2014 6:57 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Excel tab colour when published to TM1 web

Post by smantrip »

Dear TM1 Experts -

How to enable Excel tab colour when it is publised to TM1 web.

I have two tabs A and B. When TabB is colored with Red and published to Tm1 web, the color don't apply.

Any config file settings.

Tm1 version is 10.1 and Excel is 2010.

Thank you !
smantrip
smantrip
Posts: 7
Joined: Sat Apr 26, 2014 6:57 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: Excel tab colour when published to TM1 web

Post by smantrip »

Any thoughts on this please
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Excel tab colour when published to TM1 web

Post by rmackenzie »

Perhaps the functionality you want isn't implemented. TM1 Web doesn't do everything that Excel does.
Robin Mackenzie
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Excel tab colour when published to TM1 web

Post by deepakjain2020 »

Hi Smantrip,

Give a try
http://www-01.ibm.com/support/docview.w ... wg21454721

Regards,
Deepak Jain
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Excel tab colour when published to TM1 web

Post by rmackenzie »

Hopefully Deepak's link gets you where you want to be. Unfortunately, I don't think it will, but could be wrong! The last time I looked at this on v9.1.something the palette problem was not an Excel version issue, but an issue between client and server Excel settings. What I mean is that I could set the palette on Excel on the machine I was designing the report on to be specially configured to the companies 'brand' colours. But when seen on TM1 Web, it was different because the Excel running on the server didn't have the same palette settings. Attempts to set the palette on the web server didn't seem to correct the issue. Perhaps this is all different in versions 10+? Still, I don't recall worksheet tab colouring ever being part of TM1 Web rendering - although this would definitely be a good bit of functionality.
Robin Mackenzie
Post Reply