This is a master-detail list. The left-side table shows one row for each dimension table you have defined. The right-side table shows one row for each column in the selected left-side table.

The list context menu shows actions you can take that affect the row table.

Master List Columns

Table Name The name of the table you assigned when creating this dimension table.
Business Name The business-friendly name of the table that will be used in metadata generation, for display on reports, visualisations, etc.

Detail List Columns

Column Name The name of the each column in the selected table.
Data Type The Ajilius data type which will be used to store data for this column.
Role Role that this column plays in defining database structure and processing. See Column Roles.

List Menu

 Change Table Change the table name, description, documentation, etc. using the Table Edit form.
Delete Table Delete the table definition using the Table Edit form.
Columns Show the Column List for the selected table, to support column editing.
Scripts Show the Table Scripts form for the selected table, to review and test generated ELT scripts.
Create Role Create a role-playing dimension that will be implemented as a view over the base dimension. For example, an “Invoice Date” dimension may be created as a role over the “Date” dimension.
Create Rollup Create a roll-up dimension that will summarise the dimension at a higher level. For example, a “Month” dimension may be created as a rollup from the “Date” dimension.
View Data View a sample of data from the selected table, using the Table View form.