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.
Tm1 Functions not working
- LeeTaylor1979
- Posts: 63
- Joined: Mon Aug 25, 2008 12:53 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2010
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
A #value for a TM1 Excel formula usually means that the TM1 Add-in is not loaded.
- 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
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?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
If so, even if you log in as admin you will not see\be able to access admin options such as maintain dimension.