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
Need help with feeder
- 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
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
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
Jodi Ryan Family Lawyer