Essbase @ISUDA

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)
Parameter Description
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 the Oracle Essbase Database Administrator’s Guide.

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.

See Also

  • @UDA