@ISATTRIBUTE

The @ISATTRIBUTE calculation function for Essbase tells whether a member is a specific attribute.

This function returns TRUE if the current member under calculation matches the attribute or varying attribute name specified in attMbrName.

Syntax

@ISATTRIBUTE (attMbrName)

Parameters

attMbrName

Single attribute member name or member combination.

Notes

  • This function provides the same functionality as @ISMBR (@ATTRIBUTE(attMbrName)), but is faster.

  • You may have duplicate Boolean, date, and numeric attribute member names in your outline. For example, 12 can be the attribute value for the size (in ounces) of a product as well as the value for the number of packing units for a product. To distinguish duplicate member names, specify the full attribute member name (for example, @ISATTRIBUTE(Ounces_12)).

Example

Consider the following calculation script, based on the Sample Basic database:

/* To increase the marketing budget for markets with large populations */
Marketing ( 
  IF (@ISATTRIBUTE(Large)) 
    Marketing = Marketing * 1.1; 
  ENDIF 
);