Need help with feeder

Post Reply
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

Need help with feeder

Post by telula »

I want to put a flag=1 for the following accounts and companies.

What feeder should I put ?

['Flag']=N:IF(ELISANC('account','X000000',!account)<>0,IF(ELISANC('company','AUS',!company)<>0,1,0),0);

Thanking you in advance
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: Need help with feeder

Post by Martin Ryan »

You can't write a feeder for that without seriously overfeeding. I'd suggest one of two different approaches.

1) Create an attribute called Flag against both of the dimensions and either populate the data manually, or write a rule in the attributes cube without skipcheck of feeders.
2) Don't have a Flag field. Instead use the if statements you've written below but nest them in the calculation that you were intending to use the Flag field for.

Personally I'd go with 1.

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