Help with Feeder for IF rule

Post Reply
dfrench77
Posts: 52
Joined: Thu Feb 17, 2011 2:52 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Help with Feeder for IF rule

Post by dfrench77 »

All,

I am trying to feed the following rule with the following feeder.

Skipcheck;
['LC AMT']=N: IF(ATTRN('Account_CF', !Account_CF, 'Class ID') = 45, ['LC AMT'] * -1, CONTINUE);

Feeders;
['LC AMT'] =>DB(IF(ATTRN('Account_CF', !Account_CF, 'Class ID') = 45), ['LC AMT'] * -1), ['LC AMT']);

When saving the rule I receive the following syntax error on line 37 which is the feeder statement line.

Any help that can be provided will be greatly appreciated.

:roll: ---------------------------
Xcelerator Error
---------------------------
Line 37: Syntax error on or before:
), ['LC AMT'] * -1),
missing comma
Rule could not be attached to the cube, but changes were saved.
---------------------------
OK
---------------------------
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: Help with Feeder for IF rule

Post by Gregor Koch »

Hi
Your rule basically says
['LC AMT'] = ['LC AMT']*-1;

That is not ever going to work because it is a circular reference. Let alone that the Feeder would have to be

['LC AMT']=> ['LC AMT'];

You get my drift?

If you have a working rule, post that exactly as it is in the rule editor and people can help you.
dfrench77
Posts: 52
Joined: Thu Feb 17, 2011 2:52 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Help with Feeder for IF rule

Post by dfrench77 »

Thanks. Yes, I get your drift. I need to create another measure to basically perform the flipping of signs for certain account classes. That makes sense now that you pointed it out. :oops:
Post Reply