Search found 26 matches

by Malcolm MacDonnell
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

Creating a Sandbox with TI/VBA

Hi All,

Is anyone aware of a way to create a sandbox with code (TI or the API?)

Some undocumented feature maybe?

Thanks
Mal
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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 ...
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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...
by Malcolm MacDonnell
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.
by Malcolm MacDonnell
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...
by Malcolm MacDonnell
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); ...
by Malcolm MacDonnell
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...
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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
by Malcolm MacDonnell
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)
by Malcolm MacDonnell
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...
by Malcolm MacDonnell
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...