Tm1 Functions not working

Post Reply
User avatar
LeeTaylor1979
Posts: 63
Joined: Mon Aug 25, 2008 12:53 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Tm1 Functions not working

Post by LeeTaylor1979 »

I am currently in the USA on business and Yesterday our TM1 server went down.

I have managed to get it up and running again but I now have the following problems.

I wonder if anyone can give me some guidence as I am under a very tight deadline.

1. Dynamic Tm1 spreadsheets are showing #value so cannot view the data ?

2. Tm1 web is not working we have a server error ?

3. I do not have Admin rights when remotely accessing the Server but on excel client I do ?
Also my Perspectives has changed Client

Any help would be appreciated.
User avatar
jim wood
Site Admin
Posts: 3961
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 Functions not working

Post by jim wood »

Did you restart the TM1 excel service??
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Kaveenga
Posts: 59
Joined: Mon Jun 02, 2008 8:49 pm
OLAP Product: TM1 Palo
Version: TM1 9.x Palo 3.2
Excel Version: 2003 2007 2010

Re: Tm1 Functions not working

Post by Kaveenga »

A #value for a TM1 Excel formula usually means that the TM1 Add-in is not loaded.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Tm1 Functions not working

Post by stephen waters »

LeeTaylor1979 wrote:I am currently in the USA on business and Yesterday our TM1 server went down......

3. I do not have Admin rights when remotely accessing the Server but on excel client I do ?
Also my Perspectives has changed Client
Not completely clear from your description but are you trying to access TM1 server from a TM1 Excel client pc that does not have the Perspectives license file , TM1P8.LIC installed?

If so, even if you log in as admin you will not see\be able to access admin options such as maintain dimension.
Post Reply