Returns TRUE if the current member belongs to the list of base members that are associated with an attribute that satisfies the conditions you specify.
Syntax
@ISMBRWITHATTR (dimName, "operator", value)
Parameter | Description |
---|---|
dimName | Single varying attribute dimension name. |
operator | Operator specification, which must be enclosed in quotation marks (""). |
value | A value that, in combination with the operator, defines the condition that must be met. The value can be a varying attribute member specification, a constant, or a date-format function (that is, @TODATE). |
Notes
This function provides the same functionality as @IsMbr(@WithAttr()), but is faster.
This function is a superset of the @ISATTRIBUTE function. The following two formulas return the same member set:
@ISATTRIBUTE(Bottle) @ISMBRWITHATTR("Pkg Type","==",Bottle)
However, the following formula can be performed only with @ISMBRWITHATTR (not with @ISATTRIBUTE) because you specify a condition:
@ISMBRWITHATTR(Ounces,">","16")
If you specify a date attribute with the @ISMBRWITHATTR function, you must use the @TODATE function in the string parameter to convert the date string to a number. For more information, see the topic for the @TODATE function.
The following operators are supported:
Operator | Description |
---|---|
> | Greater than |
>= | Greater than or equal to |
< | Less than |
<= | Less than or equal to |
= = | Equal to |
<> or != | Not equal to |
IN | In |
When using Boolean attributes with @ISMBRWITHATTR, use only the actual Boolean attribute member name, or use 1 (for True or Yes) or 0 (for False or No). You cannot use True/Yes and False/No interchangeably.
See Also