Adding Prefixes and Suffixes

Within data load and dimension build rules files, you can add prefixes or suffixes to data-source values. For example, you can prefix member names with ESS, provided that the resulting names are valid member names.

  To add prefixes or suffixes to data-source values:

  1. Open or create a rules file.

  2. Select a field.

  3. Select Field, then Properties.

  4. In the Field Properties window, select the Global Properties tab.

  5. In Prefix or Suffix, enter a prefix or suffix, respectively.

  6. Click OK.

Related Information