SUDA

The Essbase Report Writer SUDA command selects members based on a common attribute, defined as a UDA (user-defined attribute), along with their shared counterparts.

Syntax

<SUDA (dimName, udaStr)

Parameters

dimName: Name of the dimension associated with udaStr.
udaStr: Name of the UDA.

Notes

You can use the <SUDA command as a standalone command or as a selection command inside the LINK statement.
You cannot use attributes as arguments.
With the <UDA command, Report Extractor selects only the members tagged with the specified UDA. Shared members are not selected. For example, consider the following outline structure:
```
Product 
  100
    100-10
    100-20 (UDAS: No Carb) 
  200
    200-10
    200-20 (UDAS: No Carb)
Diet
  100-20 (shared)
  200-20 (shared)
```
The following command returns no members, because the children of Diet are not recognized as having the UDA "No Carb":

<CHILDREN (Diet) and <UDA (Product, "No Carb")

In contrast, the <SUDA report command enables Report Extractor to recognize all instances of shared members as having the UDA associated with the prototype member. For example, the following command:

<CHILDREN (Diet) and <SUDA (Product, "No Carb")

returns the following members:
```
[Product].[100].[100-20]
[Product].[200].[200-20]
[Product].[Diet].[100-20]
[Product].[Diet].[200-20]
```
because these members are children of Diet, and the "No Carb" UDA associated with the prototype members is also associated with the shared members.

Example

The following example uses the SUDA command within a LINK statement to select shared members under Diet that are not "No Carb":

<LINK (<DESC(Diet) and not <SUDA (product, "No Carb))

Related Topics