Working with User-Defined Attributes (UDAs)
You can use user-defined attributes (UDAs) within member formulas and reports. UDAs return lists of members associated with the attribute. For example:
-
For a Product dimension with several product members, you can create a UDA called
New Products
and assign this UDA to the new products in the Product dimension hierarchy. Then you can base certain calculations on theNew Products
designation. -
If you use the
@XREF
function to look up a data value in another database to calculate a value from the current database, you can add theHSP_NOLINK
UDA to members to prevent the@XREF
function from being created on all application types that are not the source type selected for that member.
UDAs are specific to dimensions. For example, creating a UDA for an Account member makes it available for non-shared Account members. Deleting it removes it for all Account members. To make UDAs available for multiple dimensions, create the same UDA for multiple dimensions. For example, create a UDA named New
for the Account and Entity dimensions to make it available for Account and Entity members.
To select UDAs for members: