Value and Label criteria let you filter Members according to their value. Value criteria apply to Dimensions with numeric-value Members and Label criteria apply to Dimension with text-value Members.
Examples:
- Filter product serial numbers that start with XXX
- Filter products whose ID number is between 100 and 1000
Comparing Numeric Member value to Explicit Value
| Component | Description |
| 1 | The comparison operator to use (click to modify) |
| 2 | The explicit numeric value to compare to |
| 3 | Add another criteria with an AND/OR logical operator |
Comparing Text Member value to Explicit Value
| Component | Description |
| 1 | The comparison operator to use (click to modify) |
| 2 | The explicit text value to compare to |
| 3 | Add another criteria with an AND/OR logical operator |
| Comparison Expression | Description |
| Contains | Member value contains the specified text |
| Doesn’t Contain | Member value does not contain the specified text |
| Doesn’t End With | Member value does not end with the specified text |
| Doesn’t Start With | Member value does not start with the specified text |
| Ends With | Member value ends with the specified text |
| Equals | Member value equals the specified text |
| Not Equal | Member value does not equal the specified text |
| Start With | Member value starts with the specified text |
See Also