How to enable Advanced Code Editing Features in rule editor.

[ryan]

I am using normal tm1 rule editor. I would like to use advanced code editing features in TM1 rule editor.

Can anyone help me how to enable that feature? Currently I am working on TM1 9.0

Thanks in advance.

[Alan Kirk]

I am using normal tm1 rule editor. I would like to use advanced code editing features in TM1 rule editor.

Can anyone help me how to enable that feature? Currently I am working on TM1 9.0

Thanks in advance.

Well, the first step would be to upgrade given that the first incarnation of the allegedly enhanced Rules Editor came with 9.1...

But of course if you do that and are still on 32 bit, you may find that your model no longer gets out of bed. If you're not... it's probably time to look at upgrading anyway. I'd rather be on 9.5.1 than 9.0 but first I need a new server, a 64 bit licence and the money to pay for both.

(Frankly I'm surprised that you're using Excel 2007 with 9.0; it works, but it's a pain to use given the bogus error messages that you get when loading the add-in.)

[Kyro]

Your configuration details in your signature say: IBM Cognos Express Xcelerator (Version 9.0)

If this is true then you are really using TM1 version 9.4. On TM1 Tutorials.com "Basic 10 Point TM1 Healthcheck" we have the Advanced Rules Editor setting and where to find the config file location: 10 Point Health - Check Page 3

[Alan Kirk]

Your configuration details in your signature say: IBM Cognos Express Xcelerator (Version 9.0)

If this is true then you are really using TM1 version 9.4.

Ah, quite right; I was only looking at his profile in the side panel.

[David Usherwood]

Be aware that in my experience the 'Advanced' editor (hah!), pretty as it is, doesn't work properly, at least in the Northern Hemisphere. Specifically, you can't enter multidimensional references eg ['2015','Jan']. It also can't do subset lists eg [{'Jan','Feb'}] but then the 'real' editor can't either.

[lotsaram]

Actually it does do element arrays {'Jan','Feb','Mar'} etc. (which the plain text editor doesn't)

But it is true it (STILL after x number of releases and 3+ years) doesn't do multidimensional intersections. (however it ain't that difficult to select independently for each dimension and go back after the fact and manually delete the unwanted square brackets)

[David Usherwood]

My mistake - since it's broken for intersections, I don't use it except for presales.

[Andy Key]

It does do intersections if you turn on AutoComplete. Using the [ ] button, you select your first dimension element, hit comma and the drop down list of dimensions appears again.

The downside of using AutoComplete used to be that when you typed in an element name such as Capitalisation it came over all Microsoft, assumed it knew better than you, and after you had typed just C-a-p it automatically completed it (well, you have just turned AutoComplete on...) to the function name Capit. The problem being that when you continued typing it just appended to the end of Capit rather than accepting that it got it wrong and reverting to just Cap, so you ended up with Capititalisation.

Having just turned the Advanced Rules Editor back on in 9.5.2 HF6 it now works correctly. I think I had only previously tested this against 9.5.1, so I don't know if earlier versions of 9.5.2 worked as well. It may even be in the later HFs for 9.5.1.

I'll leave it on for a while and see what the next show stopper is, although I'm still not a fan of the ten second startup time the first time you use it. But at least I don't have to worry about whether I can enter £ signs any more.

[Andy Key]

Knew it was too good to be true.

If you are typing something within quote marks, the auto complete is still broken.
(Unless you are in the Feeders section, in which case it is fine...)

AdvancedRulesEditor=F