If you have permission to edit dimensions on sheets, you can add and rename dimension values for dimensions on cube sheets and modeled sheets if those dimensions have been configured to allow editing on the sheet.
Add a New Value
If available, an Edit Dimension button appears at the bottom of the dimension's selector.
To add a new dimension value:
- Open the dimension selector and click Edit Dimension. An Edit Dimension dialog box opens, allowing you to edit the dimension by renaming elements of the dimension or adding new elements.
- Select the location where you want to add the new dimension value by selecting a dimension value in the tree.
- Decide if the new dimension value will be a child or a sibling of the selected dimension value and click Add Child or Add Sibling. The location where you are inserting the new dimension value will be highlighted.
- Type a Name for the new dimension value.
- Click Save. After saving, the dimension tree highlights the newly-added value.
Rename an Existing Value
To rename a dimension value:
- Select a dimension value
- Change its name in the details panel. Only dimension values can be renamed; the dimension itself cannot be renamed from this dialog.
- Click Save.
Note: When you add a new dimension value to a dimension that is associated with a lookup table in a modeled sheet, the associated row is created in the lookup table and the values are blank.