Page 1 of 1
Subsets in Rules?
Posted: Tue Oct 27, 2009 6:37 pm
by image2x
Could someone confirm that you cannot make use of Subsets in rules?
I'm guessing this is the case and I've search and searched but haven't been able to rule this out.
Thanks.
Re: Subsets in Rules?
Posted: Tue Oct 27, 2009 9:05 pm
by Martin Ryan
You're right you can't. They're too dynamic, especially for feeders.
Cheers,
Martin
Re: Subsets in Rules?
Posted: Tue Oct 27, 2009 9:19 pm
by paulsimon
Hi
The nearest you can get to a subset on the left hand side of a rule is a hard-coded subset in { } allowing you to make the rule apply to more than one element from the same dimension, eg
[
{'GBP','EUR','USD','AUD'},
'Value'
]
With feeders you can use consolidations on the left and right hand side of the rule, which effectively say feed from every element below the LHS consolidation with a non-zero value to every element below the RHS consolidation.
In rules it is also possible to use an attribute tag eg
['Sales'] = N:
IF( attrn('Entity',!Entity,'SelectedEntity' ) = 1
,
['Units'] * 5
,
['Units'] * 3
) ;
Which effectively allows you to pick the Entities to which you want the special rule to apply.
Regards
Paul Simon