You use the Global Properties tab to modify the values of a selected field during a data load or dimension build.
You modify the values of a selected field by performing one or more of the following actions:
Select a Case option to determine whether field values retain their original case or are converted to upper or lower case.
In the Prefix box, enter a text string—to precede each field value.
In the Suffix box, enter a text string—to append to each field value.
Select the “Drop leading/trailing spaces” option, Fields that contain leading or trailing spaces cannot map to member names. The option is selected by default.
Select the “Convert spaces to underscores” option.
In the Replace column, enter the text string that you want to replace, and, in the With column, enter the text string that replaces the string in the Replace column. If you want to replace the text string only when it occurs as an entire word, select the Match Whole Word option. If you want to replace all text strings that match the text string in the With column, select the Replace All Occurrences option. By default, Essbase replaces only the first occurrence.
You define a search operation by clicking the New button or by pressing the Enter key. You click Delete to remove the selected search operation.