TM1 Forum

Fellow forum members -

I my efforts to edit a rule (written by our VAR), which I am now kicking myself for not copying the original to a text editor before modifying, I seem to have rendered its syntax to be incorrect. I'd like to find which directory the rule for this Element attribute is stored so I can view the backup of the data directory from and copy the backup.

The syntax looks correct to me:
but I am getting an error message that I am missing a comma:
Any of the following will help me -

- The directory where I can find the rule for }ElementAttributes_Time
- The syntax error in the rule

Thank you in advance for your help!

shinymcshires wrote:Any of the following will help me -

- The directory where I can find the rule for }ElementAttributes_Time
- The syntax error in the rule

Thank you in advance for your help!

Hi:

Saved rules can be found as .RUX files in your TM1 server's data directory.

I believe the syntax problem is that you didn't completely finish the inline IF() function here. You need to specify:

IF( <some condition>, <do this when condition is true>, <do this when condition is false> )

It's the final part of the IF that you're missing, from what I can see. Your rule at the moment is setting "Budget Months" = "" when the FY attribute of the current period = the "Budget Year 1" or "Budget Year 2" Control Panel cube settings. You haven't told the rule what to do when the FY attribute does not equal either of those Control Panel cube settings.

HTH!

Regards,
Mike

Mr. Cowie -

Once again, you provide a great answer. I could have sworn I looked at all of the .rux files in the data directory. Oh well. I found the syntax from the backup copy of the rule, and you are absolutely right about the syntax. the 'TRUE' section of the IF statement should have been 'Y", then the FALSE section being = ' '. Once I changed that, the rule editor was happy again.

If you ever come out to the SF Bay Area, I'm going to have to buy you lunch. Thanks again!