1. Scripting Reference for Oracle Essbase
  2. Report Writer
  3. Report Writer Command List
  4. UDA

UDA

The UDA Report Writer command in Essbase selects and reports on members based on a common attribute, defined as a UDA (user-defined attribute).

Syntax

<UDA (dimName, udaStr)

Parameters

dimName

The dimension associated with the udaStr.

udaStr

Name of the user-defined attribute.

Notes

  • If a UDA is associated with shared members, only the first instance is returned. If you want to include all instances, use the SUDA command.

  • You can use the <UDA command as a standalone command or as a selection command inside the LINK statement.

  • You cannot use attributes as arguments.

Example

The following example selects products that are sweet:

<UDA (product, "Sweet")

The following example uses the UDA command within a LINK statement to select level 0 products that are sweet:

<LINK(<UDA(product, "Sweet") AND <LEV(product, 0))

Note:

If the Product dimension includes shared members with the UDA "Sweet", this command selects only the first instance in the outline of the shared member.

Related Topics