Subsets in Rules?

[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.

[Martin Ryan]

You're right you can't. They're too dynamic, especially for feeders.

Cheers,
Martin

[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