Hi All,
Is anyone aware of a way to create a sandbox with code (TI or the API?)
Some undocumented feature maybe?
Thanks
Mal
Search found 26 matches
- Thu Mar 12, 2015 1:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating a Sandbox with TI/VBA
- Replies: 1
- Views: 2623
- Tue Mar 10, 2015 1:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to do executecommand from TI
- Replies: 12
- Views: 10422
Re: Unable to do executecommand from TI
Try using
sScript = 'cmd /C move /y ' ;
Mal
sScript = 'cmd /C move /y ' ;
Mal
- Mon Jun 09, 2014 11:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 10.2 Perspectives Error: Compatibility with Office/Excel 201
- Replies: 5
- Views: 5405
Re: 10.2 Perspectives Error: Compatibility with Office/Excel
In the task manager 32 bit apps have *32 after them.
Remove the TM1 ribbon (rename tm1pribbonx.xlam) and the problem should go away
Remove the TM1 ribbon (rename tm1pribbonx.xlam) and the problem should go away
- Thu Jul 04, 2013 10:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Version is Incompatible
- Replies: 6
- Views: 6880
Re: TM1 Version is Incompatible
Hi,
We used to do the tm1sd_abc thing too, but in 2008 R2 you can right-click on a process and select "go to service" and vica versa, so we don't need to anymore.
Just FYI
Cheers
Mal
We used to do the tm1sd_abc thing too, but in 2008 R2 you can right-click on a process and select "go to service" and vica versa, so we don't need to anymore.
Just FYI
Cheers
Mal
- Tue Aug 28, 2012 12:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1xl.ocx error
- Replies: 8
- Views: 8035
Re: tm1xl.ocx error
Did you select "Run as Administrator" to open the command shell?
Mal
Mal
- Thu Aug 02, 2012 3:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExeciteCommand not running vbscript
- Replies: 10
- Views: 8835
Re: ExeciteCommand not running vbscript
Hi KC, when I'm running vbscripts I always use something like: s_Run = 'cmd /C wscript "D:\Cognos\TM1\Production\Production Data\SendMailValidationLogsOriginal.vbs"' | sSendParameter; The /C terminates the commandshell afterwards, and there's a pair of double quotes as you have a space in ...
- Fri Jul 29, 2011 4:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Xcelerator Add-in doesn't appear via Citrix
- Replies: 4
- Views: 10303
Re: Xcelerator Add-in doesn't appear via Citrix
Sorry JT,
I'll read the whole post before I reply next time.
Mal
I'll read the whole post before I reply next time.
Mal
- Fri Jul 29, 2011 4:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Xcelerator Add-in doesn't appear via Citrix
- Replies: 4
- Views: 10303
- Tue Jul 19, 2011 12:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: publish subset & view in Excel VBA script
- Replies: 5
- Views: 4837
Re: publish subset & view in Excel VBA script
Agree with all Alan's comments. Another way I've found to clean up the bugus "Subset in use" is to right click on the cube and select "Unload Cube". Usually this means you don't have to restart the whole database, however in one previous version of TM1 (9.0 I think, but I'm not s...
- Mon Jul 18, 2011 10:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Interresting new TM1 site
- Replies: 12
- Views: 10055
Re: Interresting new TM1 site
Actually, If they took out the repeated bits (eg. the first two minutes after an add are the same as the two minutes before) and the fillers, air crash investigation would only go for six or seven minutes anyway.
- Thu Feb 24, 2011 3:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Admin Server Error
- Replies: 9
- Views: 7778
Re: TM1 Admin Server Error
I had a dodgy wireless card in my laptop, which used to disconnect from the network occasionally. When this happened I would get disconnected from my database, and the admin server would not show the database anymore even though it was still running. The database and admin server were both running o...
- Thu Sep 02, 2010 10:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parsing Elements name to ASCII file
- Replies: 4
- Views: 3680
Re: Parsing Elements name to ASCII file
Presuming that your variables are called Product and Amount: DatasourceASCIIQuoteCharacter=''; CommaProduct = ''; nLen = Long (Product); nIndex = Scan ('.' Product); While (nIndex <> 0); Product = SubSt (Product, 1, nIndex - 1) | ',' | SubSt (Product, nIndex + 1, nLen); nIndex = Scan ('.' Product); ...
- Wed Jan 20, 2010 10:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with the client on 9.4.1 FP2
- Replies: 16
- Views: 12314
Re: Issue with the client on 9.4.1 FP2
Hi Matt, I had a client that had performance issues on the web in 9.4 FP1 compared to 9.1. We put on FP2 HF16 and it improved to better that the 9.1 experience. Their problem was only with the web, so I don't know what it did for Perspectives or Excel, but they tend to run most things through web an...
- Mon Nov 30, 2009 10:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Summing by Attribute
- Replies: 6
- Views: 6238
Re: Summing by Attribute
Hi,
You could try adding a new element into your measures dimension and populate it with a rule like:
['new element'] = N: IF (ATTRS(???) @= 'Y', ['old element'], 0);
And then sum up the new element.
Mal
You could try adding a new element into your measures dimension and populate it with a rule like:
['new element'] = N: IF (ATTRS(???) @= 'Y', ['old element'], 0);
And then sum up the new element.
Mal
- Wed Nov 11, 2009 2:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Windows 7
- Replies: 5
- Views: 4310
Re: Windows 7
Thanks for the feedback Guys
Mal
Mal
- Tue Nov 10, 2009 4:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Windows 7
- Replies: 5
- Views: 4310
Windows 7
Hi All,
Has anyone tried installing TM1 9.4 on Windows 7?
I know it's not supported, however I have a number of clients wishing to "Suck it and see" in the near future. I'm just wondering if any issues have been found/solved before I try and reinvent the wheel.
Thanks
Malcolm
Has anyone tried installing TM1 9.4 on Windows 7?
I know it's not supported, however I have a number of clients wishing to "Suck it and see" in the near future. I'm just wondering if any issues have been found/solved before I try and reinvent the wheel.
Thanks
Malcolm
- Tue Jun 23, 2009 5:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hiding TM1 toolbar
- Replies: 7
- Views: 6324
Re: Hiding TM1 toolbar
Hi telula,
In the registry under
HKCU\Software\Applix\TM1 Perspectives
is a list of toolbars with true or false against them. Set them to false and the toolbars will go away. The problem is that Server Explorer will still be available in the TM1 menu.
Mal
In the registry under
HKCU\Software\Applix\TM1 Perspectives
is a list of toolbars with true or false against them. Set them to false and the toolbars will go away. The problem is that Server Explorer will still be available in the TM1 menu.
Mal
- Mon May 18, 2009 5:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to register subset
- Replies: 1
- Views: 7629
Re: Unable to register subset
This means that the subset you are trying to create already exists.
Oops! Just noticed that you had the RAND so that's unlikely to be your answer. Maybe it doesn't like the dot in the name (although you can save it that way without TI)
Oops! Just noticed that you had the RAND so that's unlikely to be your answer. Maybe it doesn't like the dot in the name (although you can save it that way without TI)
- Mon Dec 15, 2008 10:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No return() or halt() function found on macro sheet
- Replies: 8
- Views: 9586
Re: No return() or halt() function found on macro sheet
I had this problem a few years ago, don't remember versions of Office or Excel at the time, but I imagine it was XP with 8.2.12. In my case it was related to having the Sharepoint client installed. I could fix it by removing the client, or by making a registry change. I don't remember the actual reg...
- Fri Nov 28, 2008 9:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Delete the rule, keep the value. What the???
- Replies: 7
- Views: 6306
Re: Delete the rule, keep the value. What the???
We had this same problem (V8.2.12) or similar. An overhead populated by an FTE or STET'd if empty. When the FTE is removed the overhead stays. This does not always happen, and we never worked out why. After upgrading (9.1.3) we still have the problem, so I just wrote a TI that runs every night to cl...