Skip to main content
In a table widget, the names displayed by the row and column headers can be edited in place. For example, the header cell for contributors.COUNT can be renamed to Number of trades. This name is more meaningful to business users. A new name only changes what the widget displays. The level member or measure behind the cell is left untouched, and so is the data in the cube.
Renaming is available only in the Pivot table, Tree table and Table widgets.

​
How to rename a header cell

  1. Click the header cell displaying the name to change.
  2. Type the new name. To edit the current name instead of replacing it, press F2.
  3. Press Enter or Tab to apply the new name, or Escape to discard it. Leaving the cell in any other way, for instance by clicking another cell, applies the new name too.
See keyboard shortcuts for all the keys available while renaming.
A column header displaying the measure name contributors.COUNT
The same header cell being edited, displaying the new name Number of trades
Only the cells displaying the name of a member or a measure can be renamed. Value cells, the level names in the top left corner of the table, and totals and subtotals cannot.

​
How to restore the original name

Applying an empty name brings back the name coming from the cube: press Backspace on the renamed cell to clear its name, then Enter.
The renamed header cell cleared by pressing Backspace

​
How are renamed headers highlighted?

Every renamed cell is highlighted with a vertical bar along its left edge, setting it apart from the names coming from the cube. Restoring the original name removes the bar.

​
How to configure the edited-cells highlight

In the Settings popup, Highlight edited cells turns the bar on or off for all widgets; when enabled, Edited cells highlight color sets the color it uses.
The Highlight edited cells and Edited cells highlight color settings among the other table settings
To override the preference for a single widget, toggle Highlight edited cells in its Behavior tab. With Highlight edited cells on:
The Behavior tab with Highlight edited cells on, next to a table whose Number of trades header carries a grey bar
With Highlight edited cells off:
The same table with Highlight edited cells off, its Number of trades header carrying no bar

​
What does a new name affect?

A new name belongs to the widget it was entered in:
  • Other widgets keep displaying the original name, including when they display the same member.
  • Charts and KPI widgets always display the original names, so switching the widget to one of those types displays them again.
  • Sorting, filtering, drilling down and expanding keep working even with cells renamed.
  • Copying cells and exporting to CSV use the displayed names.
  • New names are preserved when the dashboard or the widget is saved.
To rename a calculated measure for every widget and every dashboard, edit it from the data model instead, see rename a calculated measure.