Having Trouble with Feeders

Post Reply
DMM301
Posts: 1
Joined: Fri Sep 18, 2009 5:01 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Having Trouble with Feeders

Post by DMM301 »

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
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Having Trouble with Feeders

Post by Martin Ryan »

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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
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: Having Trouble with Feeders

Post by Gregor Koch »

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
Post Reply