Add, configure, reorder, and remove columns in a table, and set the data type that controls how each column behaves.
Required permission: Edit Table Data. This permission is available to Finance Users and Admins by default.
Column data types
Each column has one of the following data types:
- Text: Freeform text values.
- Number: Numeric values with configurable formatting, including decimal places, currency, number or percent display, display scale, and negative value treatment.
- Date: Calendar date values with a configurable display format.
- Dropdown (Manual Entry): A dropdown whose options you define and can edit later.
- Dropdown (Dimension-linked): A dropdown populated from a dimension's members. You select the dimension, such as Department, and optionally filter to specific members.
- Calculation: A read-only column whose values come from a formula. See Add Calculated Columns for the full detail.
Add a column
- Open the table. Enter Edit Mode.
- Select + Column.
- Enter a Column Name.
- Select a Data Type.
- Configure any type-specific settings, such as number formatting, date format, dropdown options, or the linked dimension.
- Select Save.
Configure an existing column
- Select the column header.
- In the configuration panel,change its data type, adjust type-specific settings, reorder it left or right, view its dependencies, or delete it. Click into the column header to rename it.
- Select Save.
Set up a Dimension-linked column
- Add a column and select Dropdown (Dimension-linked) as the data type.
- Click Edit Options and select the dimension to link, such as Department.
- Optionally filter to specific members from the dimension.
- Select Save.
Note: For dimension-level access control to apply to a column, the column must use the Dimension-linked type. Text and Manual Entry dropdown columns do not enforce dimension access.
Column protection
A column is protected when a calculated column. Protected columns cells cannot be edited. If you attempt the actions, Cube blocks it on save and lists the specific formulas and calculated columns that reference the column.
Remove the references first, then modify or delete the column.