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.|
|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.|