Member

Action:

The action is performed if the current data cell on which the rule is invoked has the specified dimension member (or any one of the members that result from evaluating the specified function) in its intersection.

Operator:

The available operators are In and Not In. The target value, which is the member, is selected or entered free form.

Including Attributes

Rules can include attribute values. If Source Type is Attribute, the available operator is Is, and you can type an attribute value directly in the Target Value field. If Source Type is Member, and you select the In or Not In operator in the Target Value field, you can select an attribute by clicking rule selection icon, and then clicking the Variables tab of the Member Selection dialog box. You can use the member selection function selector to select functions for the attribute, such as NotEqual and GreaterOrEqual.

When using attribute values in data validation rules, keep in mind the way attributes are evaluated. If a rule references one or more attributes from one or more dimensions, they are evaluated as an OR for attribute values from the same attribute dimension, and as an AND for attributes from different attribute dimensions. For example, if the rule includes attributes IN Red, Blue, True, Big, then all members are selected that are either (Red OR Blue) AND True AND Big. For additional information, see About Selecting Attribute Values as Members.

Condition Definition for Member Source Type

Condition Definition

Condition Definition for Attribute Source Type

Condition Definition