SUDA

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