Creating a Search Rule to Change and Reformat Member Names

  To create a search rule to change and reformat member names:

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 Transformations tab.

3. Click the Create rule button.

   The Search Rule dialog box is displayed.

4. In the Search for text box, enter the member name that you want to transform.

5. In the Replace with text box, enter the new member name which will replace the current member name.

6. Select search options to refine the transformation:

   • Case sensitive—Only members that exactly match your search criteria will be transformed.

   • Match whole word—Only members that match your search criteria and are whole words will be transformed.

   • Replace all occurrences—All members that match your search criteria will be transformed.

     Note:

     You may select any, all, or none of the search options.

7. Click OK to save your search rule.

   The search rule you created is displayed on the Transformations tab. Note the icons which reflect the status of your search options:

   • 

     Case sensitive search— “true” is displayed if you selected Case sensitive to refine your search.

   • 

     Match whole words only— “true” is displayed if you selected Match whole word to refine your search.

   • 

     Replace all occurrences— “true” is displayed if you selected Replace all occurrences to refine your search.

8. 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.