TM1 client homepage

Post Reply
mecheng
Posts: 7
Joined: Fri Jun 15, 2012 8:34 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

TM1 client homepage

Post by mecheng »

Hi,

I'm running TM1 10.1 for a client and we're trying to set the homepage for each client.
It appears that we can only select files with the extension .xls, and not .xlsx.
Is this just normal behaviour or a TM1 bug that IBM needs to fix?

Also - does anyone know what the difference is between .xls and .xlsx files when it comes to TM1 functionality on the web?

Thank You,

MechEng
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 client homepage

Post by jim wood »

The excel file extension can cause issues depending on the excel version you are running on your TM1 web server, especially when mixing with different versions on client machines. This especially applies if you have any pre 2007 versions out there still,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 client homepage

Post by lotsaram »

mecheng wrote:Hi,

I'm running TM1 10.1 for a client and we're trying to set the homepage for each client.
It appears that we can only select files with the extension .xls, and not .xlsx.
Is this just normal behaviour or a TM1 bug that IBM needs to fix?

Also - does anyone know what the difference is between .xls and .xlsx files when it comes to TM1 functionality on the web?

Thank You,

MechEng
Yes you could regard it as a bug. But not one that IBM ever bothered to fix, well at least until 10.2 from which TM1 Web ONLY supports xlsx.

Note that although you can't set the user homepage to a .xlsx file with the GUI provided in ClientGroup security you can directly edit the hompage value in the ClientSettings cube to a application entry blob that just happens to be for a .xlsx file and the homepage will come up just fine.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
mecheng
Posts: 7
Joined: Fri Jun 15, 2012 8:34 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: TM1 client homepage

Post by mecheng »

lotsaram wrote:
mecheng wrote:Hi,

I'm running TM1 10.1 for a client and we're trying to set the homepage for each client.
It appears that we can only select files with the extension .xls, and not .xlsx.
Is this just normal behaviour or a TM1 bug that IBM needs to fix?

Also - does anyone know what the difference is between .xls and .xlsx files when it comes to TM1 functionality on the web?

Thank You,

MechEng
Yes you could regard it as a bug. But not one that IBM ever bothered to fix, well at least until 10.2 from which TM1 Web ONLY supports xlsx.

Note that although you can't set the user homepage to a .xlsx file with the GUI provided in ClientGroup security you can directly edit the hompage value in the ClientSettings cube to a application entry blob that just happens to be for a .xlsx file and the homepage will come up just fine.
thank you for your feedback and resolution!
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: TM1 client homepage

Post by PlanningDev »

Do you have a sample of what the link would look like when pointed to the .xlsx blob? I first went in and picked a .xls file then edited the back half of the string to change the folder over to }Applications\etc.\etc.\.blob.

Doesn't seem to pull up for me on login.
Post Reply