@ISUDA

The @ISUDA calculation function for Essbase tests whether a member has a certain UDA.

This function returns TRUE if the specified user-defined attribute (UDA) exists for the current member of the specified dimension at the time of the calculation.

Syntax

@ISUDA (dimName,UDAStr)

Parameters

dimName: Dimension name specification that contains the member you are checking.
UDAStr: User-defined attribute (UDA) name string.

Notes

Essbase checks to see if the UDA is defined for the current member of the specified dimension at calculation time. It returns TRUE if the UDA is defined, FALSE if not.
For more information about UDAs, see Create User-Defined Attributes.

Example

The following example is based on the Sample Basic database. The Market dimension has members that indicate a geographic location. Some members represent major markets. The example below calculates the database and stores a budget amount for the upcoming year based on the actual amount from this year. A different sales growth rate is applied to major markets than to small markets.

FIX (Budget)
   Sales (IF(@ISUDA(Market,"Major Market")) 
      Sales = Sales->Actual * 1.2; 
   ELSE 
      Sales = Sales->Actual * 1.1; 
   ENDIF;);
ENDFIX

The preceding example tests to see if the current member of Market has a UDA called "Major Market". If it does, the Budget -> Sales value is set to 120% of Actual -> Sales. If it does not, the Budget -> Sales value is set to 110% of Actual -> Sales.