Renaming Ranges on Multiple-Grid Worksheets

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase

When you place ranges on a multiple-grid worksheet, Excel assigns each range a name by default. The strings used in the name ranges may not be particularly user friendly. For example, a range based on the Essbase Demo Basic database might look like this:

Demo_Basic_C2034305_D2AC_449B_B4AE_56EA047EDF05_1

A more user-friendly name would be helpful for all users of the workbook, but changing the name using the Excel Name Manager could cause a loss of metadata in Oracle Smart View for Office.

Use the Rename Range command in the Smart View Document Contents pane to change the name to a more descriptive or user-friendly name.

Note:

To change range names in multiple-grid worksheets, you must use the Rename Range command in the Document Contents pane.

To rename ranges on a multiple-grid worksheet:

1. In the Document Contents pane, highlight the range to rename in the tree, and then click Select.

   In the following example, EssbaseCluster-1 | Sample | Basic is highlighted in the tree.

   

   Use the Select command to verify that you are working with the correct grid on the sheet. For example, after highlighting EssbaseCluster-1 | Sample | Basic and clicking Select, the Sample Basic grid on the worksheet is highlighted.

   
2. In the Action Panel, click More, and then select Rename Range.
   

   The Rename Range dialog box is displayed, showing the default name that was assigned to the range by Excel.

   
3. In Rename Range, type a new range name, and then click OK.

   We're renaming the range MySampleBasic.

   
4. Verify that the range name is changed in the Name Manager in Excel.

   Here is an example Name Manager, accessed from the Formula ribbon in Excel:

   

   You can also view the changed range name in the Excel Name Box drop-down list.