Using the Rename Utility

  To use the Rename Utility:

1. Make a backup of the Web Analysis repository.

2. Create a map file that defines old and new values in the data source that need to be replaced in the Web Analysis repository. See Rename Utility Map File.

3. Launch the start script (RenameUtil.bat or RenameUtil.sh).

4. Select the Repository Type (Microsoft SQL Server, DB2, MySQL or Oracle).

5. Enter the necessary RDBMS Repository connection fields:

   • Server Name

   • Database Name / Tablespace Name (Oracle)

   • Port Number

   • SID (Oracle only)

   • Web Analysis User

   • Oracle's Hyperion® Web Analysis Password

6. Select the map file location.

7. Click Finish.

   The Confirm tab is displayed with connection confirmation and map file verification.

8. Click Rename.

   A confirmation message is displayed.

9. Click Yes to proceed with processing.

   The process begins with all activity listed in the Confirm tab. For example:

   Preparing rename mapping rules... Reading rename mappings from renamer-map.xml Building list of rename mappings. Processing Web Analysis Reports Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Product Sales" (ID = 214) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Product Profitability" (ID = 217) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Regional Analysis" (ID = 220) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/KPI Scorecard" (ID = 223) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Expense Analysis" (ID = 226) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/State Rankings" (ID = 229) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/High\Low States" (ID = 232) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Margin Chart" (ID = 235) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Product Share" (ID = 238) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Product Budget" (ID = 241) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Sales Forecast" (ID = 244) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/Profit vs Sales" (ID = 247) Report "/Groups/Everyone/Reports/_Sample Reports/Samples/KPI Details" (ID = 250)