Selects members based on a common attribute, defined as a UDA (user-defined attribute) along with their shared counterparts.
Syntax
<SUDA (dimName, udaStr)
Parameter | Description |
---|---|
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 original instance of the 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 first instances of the 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))
See Also