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

The fact 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 fact 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.
Dimensions Add one or more dimensions to the fact table. See tutorial for more information.
Scripts Show the Table Scripts form for the selected table, to review and test generated ELT scripts.
Export Export the metadata for the star schema based on this fact, for integration with BI products including Tableau, Qlik Sense, YellowFin and PowerBI.
View Data View a sample of data from the selected table, using the Table View form.