Use the Table editor to edit tables, by adding, changing, or removing columns, keys, indexes, and fact or dimension specific objects.
Enter a column's name, data type, length, precision, and other properties in the column's data grid row. Drag and drop a column to create related keys, indexes, or attributes.
Edit a table reference column's table and snowflake columns in its data grid row's details area. Drag and drop a snowflake column to create related keys, indexes, or attributes.
Edit a measure's name, SSAS type, measure format, aggregation type, and other properties in its data grid row.
Edit a dimension's attributes, hierarchies, and relationships directly in their tree views.
The table editor's ribbon provides the following functions:
| Button | Description |
|---|---|
| Table Column | Choose and add table columns to a table. The default is table column. |
| Import Table Assets | Display the Import Tables dialog, for importing schemas and tables from a database. |
| Key | Choose a key to add to a table. The default is primary key; if a primary key is present, then the default is unique key. |
| Index | Add an index to a table. |
| Measure | Add a measure to a fact table. |
| Attribute | Add an attribute to a dimension. |
| Hierarchy | Add a hierarchy to a dimension. |
| Relationship | Add a relationship to a dimension. |
| Autogenerate Mesures | Add a measure for each table column not already associated with a measure. |
| Apply Measure Formats | Choose to preserve or overwrite existing measure formats. |
| Generate Attribute and Relationships | Choose to generate attributes, relationships, or both for a dimension. |