Using Rules Files to Update UDAs

User-defined attributes (UDAs) are words or phrases that you create to describe members. For example, you might create a UDA called Major Market and assign it to the members that represent your larger markets.

To update (add, replace, or remove) UDAs, you can use dimension build rules files or Outline Editor.

For a discussion that compares UDAs and attribute dimensions, see Oracle Essbase Database Administrator's Guide.

  To use dimension build rules files to update UDAs:

  1. Design the data source to include a column for the members that receive UDAs and a column for the UDA values.

  2. Create a dimension build rules file.

  3. For each data-source field that contains a UDA value, set the Dimension Build field type as UDA.

  4. Optional: To enable replacement of UDA values, for the rules file, for the Dimension Build setting, select Enable UDA changes.

Note:

To remove a UDA value, use Enable UDA changes, and, in the data source, leave the relevant UDA field blank.

Related Information