Search found 7 matches

by Craig Trevor
Tue Jun 18, 2013 11:12 pm
Forum: Useful code, tips and tricks
Topic: Automatically backing up the TM1 data directory
Replies: 5
Views: 11504

Re: Automatically backing up the TM1 data directory

I use 7-zip as well. I the following code in the Epilog of a scheduled process: sExec = 'C:\Program Files\7-Zip\7z.exe'; sBackupDirectory = 'E:\TM1\TM1 Archive\'; sDataDirectory = 'E:\TM1\Server\Data\'; sFileName = 'Data.' | TIMST( NOW(), '\Y\m\d.\h\i', 1) | '.zip'; sArgs = ' a -tzip '; sCommand = s...
by Craig Trevor
Sun Jan 13, 2013 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Visual Studio, Win8, and TM1Api woes
Replies: 4
Views: 3241

Re: Visual Studio, Win8, and TM1Api woes

The program is likely looking for the tm1api.dll in the old install location: C:\Program FIles\Cognos\TM1\bin Instead of the new location: C:\Program Files\ibm\cognos\tm1_64\bin64 You can either update the program code to point to the new location, or as a quick hack copy the tm1api.dll to the old i...
by Craig Trevor
Fri Jul 15, 2011 5:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interresting new TM1 site
Replies: 12
Views: 8177

Re: Interresting new TM1 site

This seems to be a promising addition to the community.

Now to find some time to be able to go through it all ;) .
by Craig Trevor
Thu Dec 30, 2010 6:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Repairs to TM1P.XLA error
Replies: 2
Views: 4469

Re: Repairs to TM1P.XLA error

After much installing, reinstalling, rebooting, etc. I have identified that when we installed Excel 2007, we disabled everything else in the Office setup.

Cognos TM1 requires that you have 'Visual Basic for Applications' installed. Once this was installed, everything is working fine.
by Craig Trevor
Thu Dec 30, 2010 3:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Repairs to TM1P.XLA error
Replies: 2
Views: 4469

Re: Repairs to TM1P.XLA error

I am getting the same error. I have raised an issue with IBM, will update with response.

TM1 9.5.1 HF 11, Windows Server 2008 R2, Excel 2007
by Craig Trevor
Thu Aug 06, 2009 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error 87: SystemServerNotFound using TM1API.dll in C#
Replies: 9
Views: 7866

Re: Error 87: SystemServerNotFound using TM1API.dll in C#

'SERVERNAME' is the physical server box and 'tm1 server' is the name of the TM1 server.

I have tried different combinations of these to no avail.
by Craig Trevor
Wed Aug 05, 2009 2:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error 87: SystemServerNotFound using TM1API.dll in C#
Replies: 9
Views: 7866

Error 87: SystemServerNotFound using TM1API.dll in C#

i am trying my hand at connecting to TM1 using the TM1API.dll in C# I have managed to get it to compile and run (with help from http://forums.olapforums.com/viewtopic.php?f=3&t=656&start=0 ). I get an error 87: SystemServerNotFound, when i run it though. TM1APIInitialize(); hUser = TM1System...