TM1 Forum

I have hit a brick wall with my rules editor

Below is the rules that I am trying to correct.

FEEDSTRINGS;
SKIPCHECK;
FEEDERS;
['Trim Day']=>['Trim Day']S:SUBST(['Trim Day'], 4, 2);
['Day Number' ]=S:IF(['Day Format' ] =['User Start Date' ] , 2 , 1234);

When I place a a manual text field in there like 'hello', these statements work fine. I do not understand why it doesn't recoginze the measures that I am calling out. This all exsists in the same cube view, so there is not any DB functions needed.

I do not understand how to Feeder from the same cube view??

Please help!!

Dave

If it's a small cube - and this looks like a "Server Properties" type cube, then I usually wouldn't bother with feeders.

You have several problems, the first is that your rules and feeders are all mixed in together, the second is that you're using a cell to feed itself, which doesn't make any sense. In fact for the first rule you cannot feed it, because it doesn't rely on any other cells except itself - you have a circular rule.

Martin

Hi
Without going into the details...
'Not having to use DB() Syntax because it is all in the same cube' is a misconception as you will have to use it eg when comparing strings.

Cheers