TM1 Forum

Eric, I don't know of a natural way to make TI understand such a number format - maybe someone else does. I think you're stuck with a formula here. So, let's say you have a variable called "Amount" and Amount = 12345.67- To make this work properly and avoid annoying errors, you'll need to ...

Whoops. Sorry, the mind and fingers got crossed up - thanks for highlighting my mistake Steve.

John - which security cube? It sure seems like an odd rule to have been added automatically - is this TM1 9.1 or have you been foolishly working with the 9.4 beta?

Regards,

Eric, The !}GROUPS is just a reference to the }GROUPS dimension - basically allows the rule to apply to any }GROUPS element. The "~" is TM1's way of saying the logical operator "Not". Other logical operators are "&" for "And" and "%" for "Or...

Michelle, I actually think you should definitely be able to do this (license-permitting, of course). There are separate installations for the 32-bit and 64-bit versions of TM1, both of which are capable of installing a TM1 Server. Both installations will install to different folders, the 32-bit endi...

Eric, In Excel, Rules or Turbo Integrator, you can check if an element exists in a dimension using the DIMIX(DimensionName, ElementName) function. For element name, you can specify the actual element name or a valid alias. If the function returns a 0, the element doesn't exist; otherwise it returns ...

Hi Viet, I'm not sure I'm clear about what you're asking. Are you asking under what events the TM1 Server applies locks to objects? I don't think there is a good document out there, but maybe someone else has compiled one on their own. The 9.1 documentation may give some bits and pieces, but because...

Dave, Can you clarify what you mean here? If the Applix-created TM1ChoreExecute.exe uses the TM1 API then it should work with 9.1, regardless of whether the SSL option is on or off. One problem you may encounter is that the TM1 API has additional required files/folder in 9.1, in general (highlighted...

Eric, As you've seen (S:)tring and (N:)umeric don't mix in the same rule. Have you looked at the ISLEAF function? ['FAMILY'] = S: IF(ISLEAF() = 1, ELPAR('Codes',!Codes,1), STET); At the lowest level this rule will calc the ELPAR and above that you'll be able to in put values (STET = let it stand/no ...

Hi everyone, A little bit of overlap, but I thought I'd post something similar we put together quite a few years ago (in VC++). The TM1ChoreExecute should be similar to the Applix-created EXE. Also included, however, is a TM1ProcessExecute.exe, which might be of some use. The Readme isn't incredibly...