Assigning User-Defined Attributes to Members

You can assign a user-defined attribute (UDA) to a member to describe a characteristic of the member; for example, you might create a UDA called “Ounces.”

See UDAs Overview.

See Members Overview.

  To assign a UDA to a member:

  1. Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  2. Select the UDAs tab.

  3. In the UDA value text box, enter a new UDA to use for the member.

  4. Optional: Select External source and select the desired column in the drop-down list if you want Essbase Studio to retrieve the UDA from a column in the data source.

    UDAs assigned to the member are displayed in the Existing UDAs text box.

    Note:

    For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide.

  5. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.