Member Name Transformation Sequence

Essbase transforms and reformats member names in the following sequence:

  1. Replacement strings are processed.

  2. Leading and trailing spaces are dropped.

  3. Spaces are converted to underscores.

  4. Prefixes are added.

  5. Suffixes are added.

  6. Case changes are made.

Note:

Because Essbase follows this sequence, you are sometimes not allowed to perform a transformation. For example, if you add a custom prefix and select a replacement string for the prefix, the operation will not work because replacement strings are processed before prefixes are added.