@ISUDA

The @ISUDA() 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)

dimName Dimension name specification that contains the member you are checking.

UDAStr user-defined attribute (UDA) name string.

Notes

Hyperion 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 the Database Administrator's Guide.

Example

This 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

This 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.

See Also

@UDA

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