@ISMBRWITHATTR

The @ISMBRWITHATTR calculation function for Essbase returns TRUE if the current member being calculated belongs to the list of base members that are associated with an attribute that satisfies the conditions you specify.

Syntax

@ISMBRWITHATTR (dimName, "operator", value)

Parameters

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 @TODATE in the string parameter to convert the date string to a number.

The following operators are supported:

Table 2-28 Supported Operators

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 this function, 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.