Working With UDAs Using Outline Editor

You can create user-defined attributes for members. A user-defined attribute (UDA) is a word or phrase that describes the member. For example, you might create a UDA called Major Market and assign it to all members in the outline that are part of a major market, as defined by your organization.

For information on comparing attributes and UDAs, see the Oracle Essbase Database Administrator's Guide.

  To create, assign, or remove a UDA:

  1. Open the outline in edit mode.

  2. Select the member or members for which you want to manage UDAs.

  3. Right-click and select Edit member properties.

  4. In the Member Properties dialog box, select the UDAs tab.

    The UDAs assigned to selected member names list box displays UDAs currently assigned to the selected members.

    The UDAs assigned in dimension-name dimension list box displays all UDAs currently defined for the dimension.

  5. If you want to assign a UDA to members selected from the outline, double-click the UDA from the UDAs assigned in dimension-name dimension list box or select the UDA and click Assign.

  6. If you want to create a UDA and assign the new UDA to all selected members, enter the UDA name in the text box and click Assign. The UDA is displayed in both list boxes.

  7. If you want to unassign a UDA, select the appropriate UDA in the UDAs assigned to selected member names list box and click Unassign.

    Note:

    A UDA is deleted from an outline when it is no longer assigned to any member and you close the dialog box.

  8. Click OK.

Related Information